printing multiple reports

  • Thread starter Thread starter marta
  • Start date Start date
M

marta

Hello,
Is there a way to create a form (switchboard) that will
allow me to print multiple reports at once with the click
of one button?
I would greatly appreciate any insight.

Thanks,
marta
 
marta said:
Is there a way to create a form (switchboard) that will
allow me to print multiple reports at once with the click
of one button?
Click to expand...

Create a form and add a command button using the button
wizard to print/preview one of your reports. Then open the
form's code module and look at the code. There should be a
line that looks like:

strDoc = "name of report one"
DoCmd.OpenReport strDoc , . . .

Add additional lines so it looks like:

strDoc = "name of report one"
DoCmd.OpenReport strDoc , . . .
DoCmd.OpenReport "name of report two", . . .
DoCmd.OpenReport "name of report three", . . .
. . .
 
Can I use a from to define which reports to print ?

How do I reference the records in the form to determine
which reports to run ?

Ta,

Alasdair
 
Can I use a from to define which reports to print ?
Click to expand...

Sure. What sort of mechanism do you want to use to make the
selections?

How do I reference the records in the form to determine
which reports to run ?
Alasdair
Click to expand...

Probably several ways to do this, which way you might want
to use depends on what you're trying to acomplish.

How do the "records in the form" relate to what you want the
report(s?) to display?
 
Back
Top