856 Chapter 28 Display Data
For each field, you can select a value from the list or type a value. When you have finished
defining the values you want to see, you click the Toggle Filter button to display only the
records that match your selected criteria.
Using Filter By Form on a table that has only a few fields, such as the one shown above,
is easy. But using it on a table that has a few dozen fields can be cumbersome, and it is
often simpler to find information in the form version of the table. When you choose the
Filter By Form command with a form displayed, Access filters the form the same way it
filters a table.)
Using the Filter By Form command with a form.After you have applied the filter, you move between the matched records by clicking the
buttons on the record navigation bar at the bottom of the form page.
In this exercise, you’ll filter a form by using the Filter By Form command.SET UP You need the GardenCompany04 database you worked with in the preceding
exercise to complete this exercise. Open the GardenCompany04 database, and then
follow the steps.- In the Navigation pane, under Forms, double-click Customers.
The Customers form opens in Form view.