Microsoft® Office Access 2003 Step by Step

Filtering by Form

The Filter By Form command provides a quick and easy way to filter a table based on the information in several fields. If you open a table and then click the Filter By Form button, what you see looks like a simple datasheet. However, each of the blank cells is a combo box with a scrollable drop-down list of all the entries in that field.

You can make a selection from the list and click the Apply Filter button to display only the records containing your selection.

Using Filter By Form on a table that has only a few fields, such as this ...