Hi All
On a form I have a button that runs a macro. The macro opens 15 different reports, but the only way i could get it to work was to have each report open in its own window (up to 15 report windows stacked on top of each other!).
The problem with this is, if they need printing, each report is sent to the printer as a single page - so the printer lists all 15 reports as a separate print job meaning each 'job' has to be released instead of just one job printing all 15 pages. Sooo much slower and a PITA
Is there a way to get all 15 reports to open in the same window?
- Each of the 15 reports has its own report template as they are all different
- It would be better for me if this could be done in a macro as i know nothing about VBA
- If it has to be done in VBA i'm willing to give it a go, but i'll prob need comments included so i can see exactly what is doing what etc.
I appreciate yur time and help and thanks in advance!
- - - - - - - - - - - - -
detjo