reports

[Guest]

How can I print and/or preview only the record that I need for a member and
not the other members. when I create a cmd button to preview the report, i am
able to view the others as well.
this is what i have:
Private Sub cmdParticipationReport_Click()
On Error GoTo Err_cmdParticipationReport_Click

Dim stDocName As String

stDocName = "Member Participation"
DoCmd.OpenReport stDocName, acPreview

Exit_cmdParticipationReport_Click:
Exit Sub

Err_cmdParticipationReport_Click:
MsgBox Err.Description
Resume Exit_cmdParticipationReport_Click

End Sub

Thank you for your time.

DC

 

[Larry Linson]

Check Help for the WhereCondition argument of DoCmd.OpenReport, create the
contents in a string, and add it to the statement.

Larry Linson
Microsoft Access MVP