Filter By Form Access. Using this approach you filter the records in a form or report by setting the filtername argument of the openform or openreport method or action to the name of the filter query you create. On the home tab in the sort filter group click advanced and then click.
The look for tab will only display records that match all the criteria set there. Using a query as a filter. A separate query sometimes called a filter query can refer to the controls on your dialog box to get its criteria.
Using this approach you filter the records in a form or report by setting the filtername argument of the openform or openreport method or action to the name of the filter query you create.
Click the empty text box below the field you want to filter click the drop down arrow and select the value you want to. Repeat step 2 for each additional field you want to use to specify additional filter criteria. Select filter by form. On the home tab in the sort filter group click advanced and then click.
