Open a Report by Command button

[kplatt]

Hi, I currently have the following code in an event procedure that by clicking a command button the following happens. the code below opens up a report in Print preview and not the regular report view. How do i change the code so that by clicking the command button, the regular report view (green folder) is opened.

Private Sub Command7_Click()
DoCmd.OpenReport "TRI Chemical Purchases", acViewPreview
End Sub

Thanks

 

[boblarson]

If you are using Access 2007 or 2010 (which I assume you are) I believe you would use acViewReportView

 

[boblarson]

Well, I was close - it is acViewReport

 

[kplatt]

I think i tried that before and i just tried to use it. This goes directly to the printer and prints without opening the form. I want the user to open and view the form. is there another code? Thanks

 

[kplatt]

I just randomly tried acViewReport and that seemed to work. Does that make sense? Thanks

 

[boblarson]

acViewReport is the correct one. acViewNormal is the one that sends the report directly to the printer without viewing.