by Dinesh Thakur Category: 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.

 



About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.