You can easily filter records by selecting values in a form or datasheet. Here are the steps:

1. 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.
   
   
2. Select the value, and then click Filter By Selection on the toolbar. How you select the value determines what records the filter returns.
   
   
3. Repeat step 2 until you have the set of records you want.

To remove a filter and show the records that were displayed previously in the table, query, or form, click Remove Filter on the toolbar in Datasheet view or Form view.

Removing a filter doesn't delete it. You can reapply the filter by clicking Apply Filter on the toolbar. When you remove a filter from a datasheet, Microsoft Access also removes any filters you applied to any subdatasheet within it.