Filter By Form Access. The filter query must include all tables in the record source of the form or report you are opening. To filter by form.
Microsoft Access 2007 2010 Part 2 Table Filter Sort Forms Computer Keyboard Shortcuts Microsoft Used Computers from www.pinterest.com
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 tab. Click the filter by form button on the toolbar.
The filter query must include all tables in the record source of the form or report you are opening.
Using a query as a filter. 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. If you want to. Click the advanced filter options button.
