Report not opening to view

[Desstro]

I built a DB in AC2010, everything works fine. Except, when I try to use AC2003. When I try to open the reoprts in AC2003 it wants to just print them. Cant open them to just view. Here is the code I have on the button that is supposed to open the report....

Private Sub OpensNightsWorkQueryReport_Click()
On Error GoTo Err_OpensNightsWorkQueryReport_Click
 
   Dim stDocName As String
 
   stDocName = "NightsWorkQueryReport"
   DoCmd.OpenReport stDocName, acViewReport
 
Exit_OpensNightsWorkQueryReport_Click:
   Exit Sub
 
Err_OpensNightsWorkQueryReport_Click:
   MsgBox Err.Description
   Resume Exit_OpensNightsWorkQueryReport_Click
 
End Sub

Help please!!

[ajetrumpet]

change:

acviewreport

to:

acviewpreview

regardless of the version you're running the db in, and you'll be fine.

[Desstro]

That works great, only I have a button in the report header set to print the report. Now I cant use that button. Is there some way to open the report and still use the button to print?

W/O allowing any toolbars.

[ajetrumpet]

Ideally, there should never be a button on a report. IMO, you should option it at the level before report opening.

I don't believe they're clickable in preview. maybe open it in layout with everything turned off? how about Ctrl+P?

[Desstro]

CTRL P works! Thanks