Delete a Record - Error

[tonyak]

I created a form and have a Delete Record button that does the following:

Recordset.Delete
DoCmd.RunCommand acCmdRecordsGoToNew

This works fine when I try to delete 1 record, but if I try to delete
another record, I get the following error:

Row handle referred to a deleted row or a row marked for deletion

What is the problem?

 

[JohnFol]

What happens if you do a requery between these two statements?

 

[tonyak]

I did a Me.Requery and that fixed the problem. Thanks.