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.
|affectrecords||An AffectEnum value that specifies which records this method will delete. Default is adAffectCurrent|
|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)|