Do one of the following:
-
To apply a filter in Form view, Datasheet view, or the Filter By Form window, click Apply Filter
on the toolbar. - To apply a filter from the Server Filter By Form window, click Apply Server Filter
.
Notes
- Microsoft Access can apply a filter automatically when you open a form if you set the form's OnOpen property to a macro that uses the ApplyFilter action or to an event procedure that uses the ApplyFilter method of the DoCmd object, or by setting the form's ServerFilter property without enabling Server Filter By Form.
- If you create a local filter in a form or subform that already contained a filter from a previous working session, the new filter replaces the previous one.
Reapply a filter to show all updated records
If you're working in a multiuser (shared) database, you may want to reapply the filter occasionally to see which records have been added, deleted, or changed since you opened the form or datasheet and applied the filter.
Reapply a filter that you created using Filter By Selection, Filter By Form, or Filter For Input
- With the filtered records displayed in a form, subform, or datasheet, click Apply Filter/Sort on the Records menu.
Reapply a filter that you created using Server Filter By Form
- Click Server Filter By Form
on the toolbar to redisplay the window, and then click Apply Server Filter
on the toolbar.
Reapply an existing filter to a data access page in Page view
You can reapply a filter that you created during the current working session.
-
Open a data access page in Page view.
-
Do one of the following:
-
On an ungrouped page, click Filter Toggle
on the record navigation toolbar so that it is selected. - On a grouped page, expand the group that you want to filter, and then click Filter Toggle on the record navigation toolbar for that group so that the button is selected.
-
Note This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be filtered independently from the rest of the data on the data access page, and may also support additional filtering capabilities. For more information, click Help
on that component's toolbar.