Using the Filter property, you can limit the records that are presented. The original records are still available in memory, but only those that meet the filter's requirements will be displayed as part of the recordset.
The following example code shows only students that have an account balance greater than $1,000:
rsStudents.Filter = "AccountBalance > 1000"
In order to return a recordset to its original contents, set the Filter property to the adFilterNone constant. The following example code disables a filter, making all original records available:
rsStudents.Filter = adFilterNone