common dialog printer problem

[ideasworking]

I'm having trouble with the common dialog api. I'm using Access VBA if that makes a difference...

After choosing a printer in the common dialog box, the report always prints to my default printer. Why is this? How do I make the report print to the printer I choose?

[jim mcnamara]

If you are using DataREport, then - it always prints to the system default printer. You have to change the default printer, no use a Set Printer = statement.

See this sample code for chanfging the default printer (not just what VB thinks is the default)

http://www.mvps.org/vbnet/code/system/defprinternt.htm