PDA

View Full Version : Report automatically prints rather than disaplying on screen



BkPlanner
05-21-2007, 12:00 PM
All --

this may seem like a simple question, but....

I have a form, a query and a report.

The report is based on a simple parameter query, and the parameter that the query requies is on the form itself. It seems to be working just fine except for one small detail.

In the code module for the form, i have this line of code

DoCmd.OpenReport("ReportName")

The code executes, and actually does run the query and produce the report, but it manages to automatically send it to my default network printer rather than disaplying it onscreen (which would be prefereable).

Can anyone offer some help on how i can get the report to disaply onscreen rather than going right to the printer.

thanks

eric

Carl A
05-21-2007, 04:28 PM
DoCmd.OpenReport ("ReportName"), acViewPreview