What is the correct VBA code for opening a report from a subform?

[Daniel B]

I created a subform so that you could click an ID# and it would open another form with the information for that ID#. I would like to do the exact same thing, but open a report instead.

The code i used to open the form is...

Private Sub TIR___Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "formNew"

stLinkCriteria = "[TIR #]=" & Me![TIR #]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

I tried the same code to try to open the report, except i changed the form to report and changed the other names, but it would'nt open the report, instead it would print the report. Any comments or advice would be helpfull.

Dan B

[gershwyn]

The OpenReport method takes 6 parameters total, with all but the first being optional.

DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

The second parameter (View) here is what is getting you. The default value is acViewNormal, which will print the report directly. You probably want to open it either in report mode or print preview mode. Try one of the following:

DoCmd.OpenReport stDocName, acViewReport, , stLinkCriteria
DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

[Daniel B]

Nice I used acViewPreview and it worked perfectly.

Thanks gershwyn.