When using Filter by Selection, you’re only able to filter one field at a time. However, when you want to filter based on several fields, you can use the Filter by Form feature.
When using Filter by Form, Access creates a blank form or datasheet that is similar to the original form or datasheet. On this blank object, you can enter data into as many fields as you want to in order to specify your criteria.
All criteria entered on the initial form must be matched before a record result will be returned. This is an AND criteria. But, you can also create an OR criteria by using the OR tabs located on the lower-left corner of the Filter by Form window. Each time you enter criteria on one OR tab, a new OR tab will appear so you can continue to add criteria.
Figure 23. Filter by Form Criteria Tabs
Applying a Filter by Form
Open the Table (in Datasheet view) or Form (in Form view) you want to filter
Choose Records: Filter: Filter by Form from the Menu bar
Enter your Filter criteria
Click the Apply Filter command on the Standard toolbar
Removing a Filter
Click the Remove Filter command on the Standard toolbar