Apply a filter (MDB)

• Click Apply Filter on the toolbar.

Notes

• When you apply a filter to a datasheet, Microsoft Access also applies filters you created in any subdatasheet within it.
• 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.
• If you create a filter in a form, subform, datasheet, or subdatasheet that already contains a filter from a previous working session, the new filter replaces the previous one.

While you can save only one filter for each form, subform, datasheet, or subdatasheet, you can use queries that you've already created as additional filters.

1. Click in the form, subform, datasheet, or subdatasheet, you want to filter.
2. Switch to the Filter By Form window or the Advanced Filter/Sort window.
3. On the toolbar, click Load From Query .
4. In the Filter box, select a query, and then click OK.
5. Click Apply Filter on the toolbar.

1. Open the report in Design view, or if the report is already open, make sure it is selected.
2. Click Properties on the toolbar to display the report's property sheet.
3. In the FilterOn property box, click Yes.

Note  Access can apply a filter automatically when you open a report if you set the report'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. You can also automatically apply a filter to a report using the OpenReport action or its corresponding method.

You can reapply a filter that you created during the current working session.

1. Open a data access page in Page view.

2. 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.

If you're working with filtered data 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.

• With the filtered records displayed in a form, subform, datasheet, or subdatasheet, click Apply Filter/Sort on the Records menu.