Filtering by Form

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.

Filtering by Form

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 ...

Get Microsoft® Office Access 2003 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.