Form will not display filter Query to Load

[chris7777]

I have a form with 2 subforms. I regularly use the same filter on the form and would like to save it as a query to load when needed. I am able to save the query but when I try to Load from Query in advanced filter the saved query does not display as an applicable filter. Therefore I can't load it. I have tried to load the query on a version of the form that did not include the subforms and was successful. Does anyone know how I can get the query to load as a filter in the form? Thanks in advance for any ideas or suggestions!

Chris

 

[Remou]

Hi
Would it be possible for you to use a command button? For example:

Private Sub cmdFilter_Click()
Me.Filter = "Code=123"
Me.FilterOn = True
Me.MySub_subform.Form.Filter = "Code='AAA'"
Me.MySub_subform.Form.FilterOn = True
End Sub