Microsoft® Office System Step by Step -- 2003 Edition

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 one, is easy. But using it on a table that has a few dozen fields gets a bit cumbersome. Then it’s ...