here is the code that came from the wizard on a button function to open a report...
Code:
Private Sub OpensLayoutQueryRpt_Click()
On Error GoTo Err_OpensLayoutQueryRpt_Click
Dim stDocName As String
stDocName = "LayoutQuery"
DoCmd.OpenReport stDocName, acViewReport
Exit_OpensLayoutQueryRpt_Click:
Exit Sub
Err_OpensLayoutQueryRpt_Click:
MsgBox Err.Description
Resume Exit_OpensLayoutQueryRpt_Click
End Sub
In 2010 it opens just fine. In 2003 it just prints out. What change do I need to make here for it to just open in 2003 rather than immediately print it?
Im sure it has something to do with acViewReport but I cant think of the term.