I use DELETE FROM SQL command and the record is deleted but ADO data control
doesn't show this after requery. Only after I reload the form it is ok. Any
clues?

Code example:
        cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
            "Data Source=c:\db\db.mdb;"
        cSqlExec = " DELETE * FROM table " + _
            " where " + _
            " id = '" + DataList1.Text + "' and " + _
            " [year] = " + DataList2.Text + " and " + _
            " [month] = " + DataList3.Text + ";"
        cnn.Execute cSqlExec

        Adodc1.Recordset.Requery
Code example ends.

best regards
--
Andres Jatsa
GSM   +372 56 463643