858 Chapter 28 Display Data
Tip No matter what method you use to enter filter criteria, the criteria are saved as a
form property and are available until they are replaced by other criteria.- Click the second box to the right of the City/State/ZIP label (the box that normally
displays the state or region), click the arrow that appears, and then in the list, click CA.
You are instructing Access to find and display records that have both a Region
value of CA and LastName values starting with S.
Only records matching both of the criteria will be displayed.- Click the Toggle Filter button.
Access displays the first of three records that meet the filtering criteria.- Switch back to the filter form, and at the bottom of the form page, click the Or tab.
The criteria you entered on the Look For page are still there, but on this page, all the
fields are blank so that you can enter alternatives for the same fields.
Tip When you display the Or page, a second Or tab appears so that you can include a
third criterion for the same field if you want.- Type s* in the second Name box, and click WA in the list for the second City/
State/ZIP box.
You are instructing Access to find and display records that have either a Region
value of CA and LastName values starting with S, or a Region value of WA and
LastName values starting with S.