Reference the Microsoft Access 8.0 object library
and place the following code in your command button.

Code:
Dim X As New Access.Application

X.DoCmd.OpenReport "ReportName", acViewNormal
Hope this helps