How can a Pass a Parameter (like a month and year mm-yyyy) to multiple queries in a macro?
Posted on 2010-01-05
I have multiple queries that I run via a Switchboard button for monhtly reporting. I would like to be able to enter the date mm-yyyy only once and have this passed to each query that needs it as that query runs.
I am using the following code to run the queries (this is an example of one)
DoCmd.OpenQuery "KO_QN_EFR_A_Product_Sum_Monthly", acViewNormal, acEdit
Can someone show me/ tell me how to do this? Thank you.