printing multiple reports

[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

 

[Marshall Barton]

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?

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", . . .
. . .

 

[Guest]

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

 

[Marshall Barton]

Can I use a from to define which reports to print ?

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

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?