Parameterized Query as Parameter

nichojo

New member
Local time
Today, 04:44
Joined
Oct 26, 2010
Messages
9
Hello everyone. I have a crazy situation that has me stumped.

Query X and Y both take two identical values and use them as parameters to run. Query Z uses query X and Y as parameters. Query Z will be executed as a querydef in VBA.

What is the best way to embed the necessary values into X and Y?
 
Nice... didn't know I could pass functions as parameters.

So theoretically all I need to do is set these variables as the common parameters and then run query z?
 
Yes that the gist. Like I explained using this approach objects such as queries using functions as parameters do not make the query exclusive to individual forms. They become available from anywhere.
 

Users who are viewing this thread

Back
Top Bottom