Select Printer

Maybe that was not clear.

I have a report that can be printed to one of 3 printers.

I want to be able to select the printer from a combo box and then click a button to print the form

Maybe that was not clear.

I have a report that can be printed to one of 3 printers.

I want to be able to select the printer from a combo box and then click a button to print the form

Points may increase depending on the answer

Best bet is to buy the code, as it's fairly complex.  I can suggest 3 sources:

1. On The Fly Printing from ATTAC consulting.  Cost $99.  Do a web search for the "on the Fly printing".  I don't have the address handy at the moment.

2. FMS, Inc Total Source Code Book
(don't know the cost).  Web site is www.fmsinc.com

3. Purchase the Access xx Developers Handbook ($49.99).

I'd recommend #1 first, as it's the most cost effective.  #3 takes a little more doing.  They give you all the code, but you need to make it work in your app.

I only recommend #2 last, because like #3, it will take a little work on your part and the cost is quite a bit more.  However you get *tons* of code you can use.

Jim.

JDettman is correct, Unlike doing this in Excel or Word, this is very compilcated because you must change the DevMode structure of the report. This  requires various API calls.