Filtering Information by Using Forms 857
- On the Home tab, in the Sort & Filter group, click the Advanced Filter Options
button, and then in the list, click Filter By Form.
The Customers form is replaced by its Filter By Form version, which has two pages:
Look For and Or. Instead of displaying the information for one record from the
table, the form now has a blank box for each field. - Click the second text box to the right of the Name label (the box that normally
displays the customer’s last name), type s, and then press Enter.
The asterisk is a wildcard that stands for any character or string of characters. Access
converts your entry to Like “s”, which is the proper format, called the syntax, for this
type of criterion.
See Also For information about wildcards, see the sidebar “Wildcards” following this
topic. - In the Sort & Filter group, click the Toggle Filter button.
Access displays the first record that has a LastName value starting with S.The record navigation bar shows that six records match the filter criterion.- Click the Advanced Filter Options button and then click Filter By Form to redisplay
the filter form.
Your filter criterion is still displayed in the form.