When you use the delete method of Recordset, you can specify a parameter
called AffectRecords to determine the affected range of the deletion.

If the Filter property is set to a string criteria, you can set
AffectRecords to adAffectAll.
If you set the Filter property to a FilterGroupEnum value or an array of
Bookmarks, you should set AffectRecords to adAffectGroup.

Note:
adAffectAll = 3. adAffectGroup=2.
By default, the parameter AffectRecords=adAffectCurrent.

For more information on this, please refer to the following articles:
Delete Method (ADO Recordset)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado2...
mdmthrstdelete.asp
AffectEnum
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado2...
mdcstaffectenum.asp

As a reminder, when you disconnect the recordset from data source, please
reconnect and execute UpdateBatch to submit the changes to the server.

This posting is provided "AS IS" with no warranties, and it confers no
rights. You assume all risk for your use. ? 2001 Microsoft Corporation. All
rights reserved.

Regards,
Kally Wang
Microsoft Support Engineer