Depending how your DE is set up you could always requery the recordset using the where clause.

The would be useful if you needed to limit the number of records in the recordset at any one time.