O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

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 Information by Using a Form

The Filter By Form command, available from the Advanced Filter Options list, provides a quick and easy way to filter a table based on the information in several fields. When you invoke this command within a table, Access displays a Look For tab containing a filtering form that looks like an empty datasheet. However, each of the blank cells is actually a combo box containing a list of all the entries in that field. You can select a filter criterion from the list or enter a new one. Then you click the Toggle Filter button to display only the records containing your selected criteria.

Filtering Information by Using a Form

Using Filter By Form on a table ...

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