VBA code is printing report instead of opening it

Question

I have a button on a form that should open a report but it sending the report to the default printer instead. How do stop it from printing? I'm using access 2010

Private Sub Generate_Click()
    If Me.Staff = "<< All >>" Then
        DoCmd.OpenReport "rptAll", acViewNormal, , , acHidden
    Else
        DoCmd.OpenReport "rptStaff", acViewNormal, , , acHidden
    End If
End Sub

Use acViewLayout, acViewReport or acViewPreview. But why are you hiding it? — Andy G

ApplePie ApplePie · Accepted Answer · 2014-06-13T22:54:15

You should use acViewReport as stated here in the MSDN doc if you want to show the report.

http://msdn.microsoft.com/en-us/library/office/ff195735%28v=office.15%29.aspx

VBA code is printing report instead of opening it

1 Answers