stringing parameter reports together (1 Viewer)

brian189

Registered User.
Local time
Today, 01:29
Joined
Sep 4, 2000
Messages
10
I have several different reports that a user can select for each record. Each report asks the user for a parameter of recordID when they wish to open the report. I have created a macro that can be used to print all the reports for a given record if the user wishes to do so. Unfortunately, the parameter dialog pops up for each report, requiring the user to enter the recordID for each report. Is there a way to string these together so the user only has to input the parameter one time?

Thanks in advance for any help!
 

Jack Cowley

Registered User.
Local time
Today, 01:29
Joined
Aug 7, 2000
Messages
2,639
Instead of poping up a parameter have the query get the data from the form. Where you have [Enter RecordID] in the query put something like: [Form]![YourFormName]![RecordID]

Now the query will read the data from the form and not ask the user.

HTH,
Jack
 

Users who are viewing this thread

Top Bottom