Use a command button to run a query and open form

[Johnny Drama]

Is it possible to open a form using a command button and having that command button pass the query criteria as well, ie, When you click the button, it opens a form and provides the query criteria to the underlying query as well. The query criteria would be fixed; the user would not need to input anything as it would be coded into the command button code. I can't figure out how to code this, if it's even possible.

 

[namliam]

the docmd.openform holds the secrets you are looking for ...

Simply use the WHERE part with the query as recordsource to the form, should work perfectly

 

[Johnny Drama]

Care to provide an example? What I have is:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmTesting"
stLinkCriteria = "[Category]= Financial"
DoCmd.OpenForm stDocName, , , stLinkCriteria

What happens presently is a critera box will open asking for a critera and is labeled "financial", if I enter "Financial" as the criteria the form will open but the criteria is not passed to the query. The whole idea is that a criteria box will not even open, the criteria is hardcoded in the command button.

 

[namliam]

If you want a literal string, tell access it is one...

stLinkCriteria = "[Category]= 'Financial' "
or
stLinkCriteria = "[Category]= ""Financial"" "