Solved OpenForm using FilterName

[Sun_Force]

I have a course in databases and currently am studying vba in MS-Access.

This is from one of our books about the parameters of Docmd.OpenForm method (Not the exact phrase. Just as far as I remember) :

You can use either an existing query or a filter that was saved as a query for FilterName.

But it doesn't give any examples. Most sample codes use the where clause to open a form.
I'm trying to open a form with an exact filter. How can I save a filter as a query?
Or maybe I should ask: How can I use FilterName parameter correctly?

Any link to on-line articles can help too.

Thanks.

 

[theDBguy]

Hi. I've never used Filter either, but you could try creating a query with the criteria you want and use the name of your query as a filter for your OpenForm method.

Hope that helps...

 

[arnelgp]

here is a sample.

 

[Sun_Force]

Thanks to both.
It was a great help.

 

[theDBguy]

Thanks to both.
It was a great help.

Hi. @arnelgp and I were happy to assist. Good luck with your project.

 

[jdraw]

As others have said, for the FilterName parameter, use the name of your saved query.
Arnelgp has shown it with macro, below is similar action using vba.

Private Sub btnOpen_Click()
DoCmd.OpenForm "Table1", acNormal, "QueryAsFilter"
End Sub