What are the steps needed to delete a record from database

1. The delete method deletes current record. The user should display the record to delete and click a Delete command button or menu choice.

2. When a record is deleted, the current record is no longer valid. Therefore, a delete method must be followed by MoveNext method.

With datBooks.Recordset

.Delete

.MoveNext

End With

3. But what if the record being deleted is the last record in the table?

4. Remember that if the navigation buttons are used to navigate, moving beyond EOF just resets the current record to the last record.