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 Datasheet view or Form 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 Datasheet view or Form view.
Notes
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.
If you prefer, you can use the ShowAllRecords action in a macro or Visual Basic for Applications code to remove the filter.
on the toolbar in Datasheet view or Form view.