I need a form to always open with a certain filter applied rather than the last filter applied. I wrote the filter in advanced filter/sort and saved it as a query.
I have tried two methods to define the query as my filter. I used the Form Property Sheet and tried the <Advanced Filter/sort> <Load From query>.
When I try to use the Form Property Sheet to define my query as the filter in the form property sheet I get a syntax error. It says that I am missing an operator. I do not know what syntax to use to get the query to work as my form filter.
The <advanced filter/sort> <load from query> did not work either. The query is not available in the Applicable Filter list when I try this method.
How do I define my query as the filter to use when users open the form?
I have tried two methods to define the query as my filter. I used the Form Property Sheet and tried the <Advanced Filter/sort> <Load From query>.
When I try to use the Form Property Sheet to define my query as the filter in the form property sheet I get a syntax error. It says that I am missing an operator. I do not know what syntax to use to get the query to work as my form filter.
The <advanced filter/sort> <load from query> did not work either. The query is not available in the Applicable Filter list when I try this method.
How do I define my query as the filter to use when users open the form?