After entering criteria in the Filter by Form window, click the Toggle Filter button to apply
the filter and see its results. (Note that the ScreenTip for this button reads Apply Filter or
Remove Filter, depending on its current state.) If you need to refine the filter, click the
Filter by Form button again, and add or remove criteria.
38
Figure 38.8
The Filter by Form
option lets you enter
expressions or choose
from a drop-down list
to refine the display
of data from a query
or table.
The Filter by Form interface looks simple, but it can be surprisingly powerful. If you enter
criteria in multiple fields, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.