One Parameter to open 2 Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top