Reports don't display but go directly to printer

B

Bill McCarthy

I sure would appreciate some advice on this problem. I've asked before but
got no response and I'm getting desperate.

I have had this problem happen twice now.

I create a report that works successfully. I then modify it in such a way
that I need some code in the OPEN event. Once I do that, the report goes
directly to the printer and I can't get it to display on the screen first.
Even if I remove the code from the event processing, it continue to do this.


Can anyone tell me what I am doing wrong? Thanks.
 
C

Coleen

Check your help in Access under "OpenReport Action" but try this code:

dim strID as yourreportname
DoCmd.OpenReport stDocName, acViewPreview, , strID

HTH

Coleen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

You don't currently have permission to access this folder 0
Report goes directly to printer bypassing display on the screen 2
Sending a report directly to a printer 1
Need help modifying code 0
DB Documentation Report Crashes 0
Report not executing code 3
OnOpen event fails to fire when Report opened from VBA code 0
Changing Report Margins from VBA code - Access 2007 1

Top