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. Click the empty text box below the field you want to filter click the drop down arrow and select the value you want to.
Select filter by form. 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.
Click the advanced filter options button.
On the home tab in the sort filter group click advanced and then click. 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. Click the filter by form button on the toolbar. Using your example on my database but instead i m only filtering one field instead of two because the complete name is all on the same cell.
