Took over another person's Access 2000 database and did a bunch of work on it to discover that no matter where I print from printing using a docmd.openreport "report name" the macro insists on printing to the printer I developed it on.
Our environment is a local LAN with connected printers. If I run this at home, the File->Page Setup dialog box opens looking for a printer. I note that I can set use of a default printer or a specific printer at this point but it really does not seem to affect things. This wierd behavior persists even though I have split the db into a front and backend. From whatever location I load the front end it insists on printing to my development area printer. This only seems to affect use of the docmd.openreport. Manual selection of a report and printing work just fine. ??????? Thanks Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/