< Complete Recordset Object Reference
The Delete method is used to delete the current record or a group of records. After deleting a record, the deleted record remains current until you move to a different record.
Note: If you are in batch update mode the deletion happens when you call the UpdateBatch method.
Note: To use this method assure that the Recordset object allows record deletion.
Note: If this method fails, the provider will not stop the execution, but it will send a warning to the Errors Collection.
Syntax
objRecordset.Delete affectrecords
| Parameter | Description |
|---|---|
| affectrecords | An AffectEnum value that specifies which records this method will delete. Default is adAffectCurrent |
AffectEnum Values
| Constant | Value | Description |
|---|---|---|
| adAffectCurrent | 1 | Deletes only the current record |
| adAffectGroup | 2 | Deletes only records that satisfy the Filter setting (Filter must be set to a FilterGroupEnum value or an array of Bookmarks) |
< Complete Recordset Object Reference