Remove a filter (MDB)
Do one of the following:
- To remove a filter and show the records that were displayed previously in the table, query, or form, click Remove Filter
on the toolbar in Form view or Datasheet view. - To remove a filter in a multiuser (shared) database and see which records have been added, deleted, or changed since you opened the table, query, or form, click Remove Filter/Sort on the Records menu in Form view or Datasheet view.
Note Removing a filter doesn't delete it. You can reapply the filter by clicking Apply Filter
on the toolbar. When you remove a filter from a datasheet, Microsoft Access also removes any filters you applied to any subdatasheet within it.