If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One Parameter to open 2 Reports
I have two reports Chem1 and Chem2 that ask for a parameter value upon
opening. How do I write a Macro that says when opening Chem1 using lets say parameter value of 44 to also open Chem2 using the same value. -- TanyO |
#2
|
|||
|
|||
One Parameter to open 2 Reports
Do this by having a form open that asks the user to enter/select the value,
then let each report's query read the value from that form's control that has the value: Forms!FormName!ControlName -- Ken Snell MS ACCESS MVP "TanyO" wrote in message ... I have two reports Chem1 and Chem2 that ask for a parameter value upon opening. How do I write a Macro that says when opening Chem1 using lets say parameter value of 44 to also open Chem2 using the same value. -- TanyO |
Thread Tools | |
Display Modes | |
|
|