Always Load Form with the same filter applied

[Renasant]

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?

 

[dhookom]

Typically, I open a form with code like:

Dim strWhere as String
strWhere = "[Active] = True"
DoCmd.OpenForm "frmMyFormName", , , strWhere

The strWhere creates a WHERE CONDITION that gets passed to the Filter property of the form.

I never have users open a form from the database window since they should never see the database window.

Duane
Hook'D on Access
MS Access MVP

 

[Renasant]

I do not have the skills to do the sequel. I need to know how to do this in Access 2007.

 

[dhookom]

If you always want a form's record source to be filtered, then change the criteria in the form's record source query to match your requirements.

Duane
Hook'D on Access
MS Access MVP

 

[Renasant]

Thanks Duane. That makes sense. I got the change in place and it works!