I've been using Access for a while now but I'm relatively new to VBA and I've came across a problem that I have no idea how to overcome.
I'm trying to print 4 separate reports from the one button, at the one time. But the user has to be able to choose which printer they want the reports to print to - this is my problem. I can get the first report to open, and display the print dialog box and then print that report to the specified printer but the second, third and fourth reports all go back to the default printer instead of the one chosen by the user at the beginning.
How can I set the printer name for all the 4 print jobs right at the beginning without having to change the default printer?
Any help on this is greatly appreciated!
Thanks,
Kathy
I'm trying to print 4 separate reports from the one button, at the one time. But the user has to be able to choose which printer they want the reports to print to - this is my problem. I can get the first report to open, and display the print dialog box and then print that report to the specified printer but the second, third and fourth reports all go back to the default printer instead of the one chosen by the user at the beginning.
How can I set the printer name for all the 4 print jobs right at the beginning without having to change the default printer?
Any help on this is greatly appreciated!
Thanks,
Kathy