Delete

Deletes the current record in an open Recordset object.

Syntax

recordset.Delete

The recordset placeholder is an object variable that represents an updatable Recordset object containing the record you want to delete.

Remarks

Using the Delete method deletes the current record from the database. If the Recordset object doesn't allow record deletion, an error occurs.

Retrieving field values from the deleted record generates an error. After deleting the current record, the deleted record remains current until you move to a different record. Once you move away from the deleted record, it is no longer accessible.

If the attempt to delete records fails a run-time error occurs.