O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required