Delete Method

Object List Next Object

Defined By: Recordset

Description:

Deletes the CurrentRecord from the underlying database.

Declaration:

Sub Delete()

Details:

If the underlying database is an ODBC database, the records may be locked for editing if the ReadOnly property is set to True. In this case, the Delete method will not delete the current record. When the current record is deleted, you must move to another valid record as shown in the example below.

With RecordSet

If Not .EOF Or Not .BOF Then

.Delete

.MoveNext

If .EOF Then .MovePrev

End If

End With