change spesific printer from VBA code

[JimYellow]

I want to change the printer that a report prints to as it prints or just before.

depending on the user that is logged in at the time.

I can copy the report and print the required version but it would be much nicer if I could just change the printer from code.

 

[PHV]

Depending of your version of access you may take a look at the Application.Printer property and Application.Printers collection.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884