One Parameter to open 2 Reports

T

TanyO

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.
 
K

Ken Snell \(MVP\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top