I have an Access2003 MDB database. It includes a delete button with VBA code for the onclick event. The code asks for confirmation of the delete, and if confirmed, it obeys Me.RecordSet.Delete, followed shortly by me.Requery.

Recently, on an increasing number of occasions (but not always), the requery gives an error message "record is deleted". The requery does appear to have worked, and by ignoring the error the program can continue successfully.

Please can anyone suggest what is happening, and why? Surely it is necessary to use requery after delete to get the data upated.