Multiple reports w/ one macro

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Is it possible to have one macro execute more than one
report? I have had to split a report in two because it
was too large and I would continuously get errors on
preview "cannot open any more databases". One report has
eight embedded reports and the other has one embed and
several Dlookups and two graphs. Can I have the macro run
one and then the other report to preview?

Also, the larger report gives me the "cannot open any more
databases" error when I attempt to print from preview.
Can the Database be configured to accept the extra
databases?

If I can't preview both reports, can I have the macro
directly print both reports?

Both reports are based on the same parameters in a form.

Thanks,

Pat
 
If I'm understanding you correctly, just list sequential OpenReport actions
in your macro. When the first OpenReport is done, the second one will run,
etc.
 
Back
Top