ANSWERS: 4
-
I don't think you can save a filter.
-
I know you can save a report, you can save a query and you can save a filter. So by elimination I would say that you cannot save a datasheet view, which makes sense since it seems to refer to how it is displayed on the screen.
-
A query. Although the design of the query is saved, every time it is opened, the query runs and extracts the required information from the underlying tables.
-
A filter cannot be saved - if you close a Table or Form that has been filtered it will display all records when it is next opened. The situation with Datasheet View is a bit more complicated - it is the default method of displaying a Table. However, if you switch a Form to Datasheet View, save it and close it, it will open as a Form the next time you open it. So I would say that neither a Filter nor Datasheet View can be saved.
Copyright 2023, Wired Ivy, LLC

by 