[VBA][Access] Open reports to view using buttons.

**emdiesse** · Feb 18th, 2006, 11:20 AM

How can I open reports in the report viewer using abutton.

This prints the form. I want to open it.

Code:

Private Sub cmdOpenSummary_Click()
    DoCmd.OpenReport ("rptSummary")
End Sub

Thanks

[edit] Ah bugger, wrong forum, could someone move this to the database forum please.[/edit]

**jmcilhinney** · Feb 18th, 2006, 08:09 PM

If this is a VBA question then I'd think that the Office Development forum would be the appropriate place.

**RobDog888** · Feb 18th, 2006, 08:14 PM

Moved

**RobDog888** · Feb 18th, 2006, 08:18 PM

Depending on if your doing this from within Access or from VB 6/ VB.NET

Print is the default action when no parameter is specified

VB Code:

Private Sub cmdOpenSummary_Click()
    DoCmd.OpenReport "rptSummary", acViewPreview, , , acWindowNormal
End Sub

Thread: [VBA][Access] Open reports to view using buttons.