Filter reports

[NewtoAccess]

Is it possible to open and filter a REPORT based on a criteria as you would a form?

If so would command be similar to:

Private Sub OpenReport_Click()
On Error GoTo Err_ViewDev_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "REPORT"

stLinkCriteria = "[siteID]=" & Me![siteID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_ViewDev_Click:
Exit Sub

Err_ViewDev_Click:
MsgBox Err.Description
Resume Exit_ViewDev_Click

End Sub

[JConsulting]

Is it possible to open and filter a REPORT based on a criteria as you would a form?

If so would command be similar to:

Private Sub OpenReport_Click()
On Error GoTo Err_ViewDev_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "REPORT"

stLinkCriteria = "[siteID]=" & Me![siteID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_ViewDev_Click:
Exit Sub

Err_ViewDev_Click:
MsgBox Err.Description
Resume Exit_ViewDev_Click

End Sub

pretty much yes...except you would change openform to openreport.

for access versions after 2002 I think you're allowed to pass criteria to a report
J

[MMcCarthy]

pretty much yes...except you would change openform to openreport.

for access versions after 2002 I think you're allowed to pass criteria to a report
J

You can do it in Access 2000