Filter By Form Tool Access. Click the filter by form button on the toolbar. Apply a filter by filling out a form open a table or query in datasheet view or a form in form view.
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. Repeat step 2 for each additional field you want to use to specify additional filter criteria. Click the empty text box below the field you want to filter click the drop down arrow and select the value you want to.
On the record selector bar verify that either the unfiltered or the dimmed.
Repeat step 2 for each additional field you want to use to specify additional filter criteria. In the filter by form window you can specify your filter criteria by using the two tabs at the bottom of the window. To filter by form. Apply a filter by filling out a form open a table or query in datasheet view or a form in form view.
