Selecting Printer - Reports

[nightjam]

I have a button on a Form which prints a report in acNormal view however I want the user to select the printer they want the report to print to.

I don't want to preview the report, but rather just select the printer they want and click print.

Any ideas?

 

[THWatson]

nightjam
Microsoft Knowledge Base has an article, #200611, which shows you how to enumerate existing printers, both Local and Network.

Also here's another link...

http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM#List

Hope this helps.

Tom