Print report for current record from form

[jfisher4]

There have been similar postings to my problem but I can't seem to find the answer. I am trying to print a report based on the current record in a form. I have a database of patients and each patient has multiple clinic visits. I want to be able to print a report of an individual visit with an on click command. The unique ID is the VisitID but it exists on a subreport rather than the main report. PatientID is the identifier of the main report.
Hope you can help.

 

[Pat Hartman]

Change the query for the sub-report to refer to the form field -

Where VisitID = Forms!YourMainForm!YourSubForm.Form!VisitID

Then use the Where argument of the OpenReport method to specify the PatientID for the main report.