Print Button for specific Printer (PDF)

[jhrBanker]

I would like to add a Button to my form to print a report (rpt-TestRpt) to a
specific printer which is not my default printer. One of my printers is
"Adobe PDF". When I "print" a document to this "printer", it will actually
create a PDF file. This is what I want the button to do. How can I code for
this?

 

[Tom van Stiphout]

On Tue, 30 Sep 2008 10:47:08 -0700, jhrBanker

Design the report, go to Page Setup, second tab, Use Specific Printer,
etc.
Then print the report as normal: DoCmd.OpenReport
"MyReport",acViewNormal

-Tom.
Microsoft Access MVP