printing one record of a query

[ytakbob]

I use a query to read from 2 tables.
Patient and patient orders.
from a form (patient information) and subform - order information..i enter my data and then would like to print just the information I entered on the current form and subform...rather than all the information (all patients and their orders)

Currently when I use openreport in a vbscript..I get all the records in the query printed

Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347

 

[mndrlion]

Set a where condition in the OpenReport command

DoCmd.OpenReport "theReportName", acViewPreview, , "where Condition"

For your case, the where condition would be something like:

"PatientID = 1234"