Filter records by selecting values in a form or datasheet

Filter records by selecting values in a form or datasheet

  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. For more information on selecting values, click .

    Repeat step 2 until you have the set of records you want.

Notes