Filtering Records

In Access 2000 filtering records may seem confusing at first. This free lesson offers step-by-step instructions.

Filtering by form

The Filter by Form feature works the same way as the Filter by Selection method, except you set up your search values on a blank form or datasheet.

To Filter by Form:

  • In Form or Datasheet view, click the New Record button. This creates a blank form or datasheet.

New Records button

  • Click the Filter By Form button.

Filter by Form button

  • When you click in a field, a drop-down list containing the criteria in the field (filter values) appears.

Picture of Great Lake Elementary form - When you click in a field, a drop-down list containing all the criteria in the field

  • Select a filter value from the drop-down list in one or more fields.

Picture of Great Lake Elementary form - Select a filter value

  • To display records meeting more than one search criteria, click the Or tab.

Or tab

  • Click the Apply Filter button to view the filtered records.

Remove/Apply Filter button