Setting the Printer w/ VBA for a Report

[nicolea]

I need some help please!!!

I have two differnet reports in a database that I am creating. One report is going to print out labels and will have to work with a specific label printer. Another report will have to print to the default print which is not a problem. Both printers are on the network. I need to know how do I specify for just the label report to print to another printer besides the default.

Any help will be nice

 

[dhookom]

Have you tried opening the label report in design view, selecting the proper printer, saving the report and exiting?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.