Here are a couple of potential solutions you could use:
1a) Apply a filter on your recordset
b) Use a For Next loop with the Update/Delete methods on the fiiltered recordset in order to achieve a similar result to one you are trying to achieve.
2. Alternatively save the recordset to disk in an XML format and then you can reissue a SQL statement against the data