Printing Several reports with one command?

[brin]

I would like to print more than one report by a click of a button on a form rather than viewing the reports individually. Is this possible? If by a macro how??

[This message has been edited by brin (edited 01-22-2002).]

 

[Sapstengel]

yip just create a macro
you can print or view a whole list of reports this way

 

[Pat Hartman]

If you take a look at the code generated for the button's click event, you will see the OpenReport Method. Look it up in help to see the various options and then add new OpenReport Method commands to print/preview the additional reports.

Macros should be avoided where ever possible since there is no error handling available within them.

 

[Sapstengel]

never had any problems with macro's here

 

[Sapstengel]

I've just checked it, but in every macro Access 2000 pro created there's an error handling.

 

[Pat Hartman]

Sapstengel,

You are looking at VBA code generated by the wizard.

If you don't believe me regarding the error trapping, check your documentation, check the knowledge base, search this site, make a macro that you know will fail and test it!