How to Filter by Form in Access
The Filter by Form feature makes it easy to create a filter using more than one criterion. You can filter by form when working in tables, forms, or queries.
In the Filter by Form window, you can specify your filter criteria by using the two tabs at the bottom of the window.
The Look for tab will only display records that match all the criteria set there.
If you specify filter criteria on an Or tab, Access will display records that match either the criteria on the Look for tab, or criteria on the Or tab.
You can also enter filter criteria by typing it yourself.
Any criteria added here will be searched for in addition to your original criteria.
Access applies the filter.
Free to distribute with our compliments; we hope you will consider our paid training.