In Access 2003 I want to be able to have the option to select a different printer when printing reports.
Currently I have a Macro Button on a form that previews a report. When I press the Preview Report Button that was created with the macro wizard, I the report opens on the screen and I have a custom print toolbar that has a print button. The problem is that when I press the print button on the toolbar, the report goes directly to the default printer. What I want is for the printer options box to appear so the user can select a differnt printer such as print to PDF.
Any help or suggestions with this would be much appreciated. I can provide more details if necessary. Thank you.