Print single record (access 2003)

[rlbroerman]

I want to be able to print one record at a time on a report from a form.
I tried a procedure from Microsoft Office Online "English Knowledge Base"
ACC2000: How to Print a Single Record from a Form in a Report
But it printed out all the records in the table that the form is looking at.
Can you help?
Rick Broerman

[HansV]

It would have been helpful if you had posted a link to the MSKB article, or at least its KB number, instead of letting us search for it.

The instructions in ACC2000: How to Print a Single Record from a Form in a Report are clear and correct, so if you follow them, the report should only display/print a single record. Can you post the code for your command button?

[rlbroerman]

Private Sub cmdPrintRecord_Click()

Dim strReportName As String
Dim strCriteria As String

strReportName = "LastName,Medicine,History"
strCriteria = "[DeaconessID]='" & Me![DeaconessID] & "'"
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

End Sub

[HansV]

This code assumes that DeaconessID is a text field. Is that correct? If it is a number field, you should use
<code>
strCriteria = "[DeaconessID]=" & Me![DeaconessID]</code>

[rlbroerman]

This is a number field. I tried your suggestion and it still didn't work. Attached is part of my database.
Thanks for the help.
RickBroerman

[HansV]

DeaconessID is not a field in the record source of your report, so a filter on DeaconessID won't work. If you add DeaconessID (from the Demographics table) to the record source, it should work the way you want.

[rlbroerman]

Hans,
It works great. Thanks for sticking with me.
Rick Broerman