delete row in datagrid

[lalee5]

Please help! I have a data grind bound to a ado database.


When I add records to the grid display the right records. the problem is when I try to delete.

if i add only 1 record and delete the same updated record the delete works fine. if I add more than two record and try to delete anyone of the displayed row it gives me the following error:

key column information is insufficiant or incorrect. Two many rows were afected by updated.


below is my updated code behind a command botton:

Private Sub ok_LostFocus()


Adotempsales.Recordset.Update
Adotempsales.Recordset.MoveNext
Adotempsales.Recordset.MovePrevious
Adotempsales.Recordset.Requery


thanks


kay