On Open to certain record

[jlclark4]

I designed several reports for a tabbed form. In each tab I added a command button to preview the report for that tab to be printed (there are no querys being use). What VB would I use for the Command button to have it open to the current record so the user does not have to use the navigation buttons to find the correct report entry. I have two fields in both the report and form that could be linked (EntryNumber) if that helps...

Thnks!

[pbaldy]

Sounds like this type of thing:

BaldyWeb wherecondition

[jlclark4]

That did solve it. Thank you! How can I get it to open to preview instead of printing it right away?

Private Sub Command939_Click()
On Error GoTo Err_Command939_Click
Dim stDocName As String
stDocName = "rptCDSCursoryReview3"
DoCmd.OpenReport "rptCDSCursoryReview3", , , "EntryNumber = " & Me.EntryNumber
 
Exit_Command939_Click:
Exit Sub
Err_Command939_Click:
MsgBox Err.Description
Resume Exit_Command939_Click
 
End Sub

[pbaldy]

If you look in VBA help at OpenReport, you'll see the appropriate argument. You haven't specified it, and the default if unspecified is to print.

[jlclark4]

I know the VB for it but I did not know where to place it...

DoCmd.OpenReport stDocName, acPreview

[weekend00]

DoCmd.OpenReport "rptCDSCursoryReview3",acPreview , , "EntryNumber = " & Me.EntryNumber

[jlclark4]

Thank you