Printing only one (current) record in a report

Dragonchaser

Registered User.
Local time
Yesterday, 18:51
Joined
May 15, 2007
Messages
31
Hi Everyone,

I'm probably going about this the wrong way all together, but what I'm trying to do is print a single record from a form in a report.
Basically after the client fills in the form they can print their "results report" using the click box (command button) in the bottom corner of the form. When the client clicks on the button it prints all the records ("result reports") of all the clients...no good of course.
Here's the code for the button:

Private Sub PrintSingleChamber_Click()
On Error GoTo Err_PrintSingleChamber_Click

Dim stDocName As String

stDocName = "SingleChamberPrintOut"
DoCmd.OpenReport stDocName, acNormal

Exit_PrintSingleChamber_Click:
Exit Sub

Err_PrintSingleChamber_Click:
MsgBox Err.Description
Resume Exit_PrintSingleChamber_Click

End Sub

Can someone point me in the right direction? :confused:
Thanks again,

Mark
 
Among the arguments for OpenReport, you'll find one for "wherecondition", which will do what you want. More info in VBA Help.
 

Users who are viewing this thread

Back
Top Bottom