Interactive Tutorial
How to Filter by Form in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
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.