Opening Multiple Reports

  • Thread starter Thread starter Sondra
  • Start date Start date
S

Sondra

I have 3 reports that need to be reviewed when a user
opens them. Each report is designed to open by entering
UserNumber. When I create the open report macro, I have
it open each report separately. Well this makes it
necessary for the user to enter the "UserNumber" for every
report.

So in synopsis...if there are three reports to be opened
the user must enter the "UserNumber" three separate times
for review.

Any suggestions on how to correct this or work around this
so that the reports can all be opened by the user entering
the "UserNumber" once.

Thanks for any answers.
 
I'm not sure if I understand what I need to do. All three
reports are currently drawn from separate queries. Are
you saying I need to make one query from all three queries
and link all the "usernumber" fields together to get the
end result of having to only enter the "UserNumber" once
 
Back
Top