Filter records by selecting values in a form or datasheet
In a field on a form, subform, datasheet, or subdatasheet, find one instance of the value you want records to contain in order to be included in the filter's results.
Select the value, and then click Filter By Selection on the toolbar. How you select the value determines what records the filter returns. For more information on selecting values, click .
Repeat step 2 until you have the set of records you want.
Notes
When you save a table or form, Microsoft Access saves the filters you created. You can reapply the filters when you need them, the next time you open the table or form.
When you save a query, Microsoft Access saves the filters you created, but it does not add the filter criteria to the query design grid. You can reapply the filters after you run the query, the next time you open it.
If you created a filter on a subdatasheet or subform, this filter is also available when you open the table or form for the subdatasheet or subform independently.
You can also filter for records that do not have a certain value. After selecting a value, right-click it, and then click Filter Excluding Selection.
For information on creating a form or report based on the filtered data, click .