March 2008
Beginner
960 pages
24h 34m
English
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.

Using Filter By Form on a table ...
Read now
Unlock full access