Only printing the record currently displayed in the form
Assuming that there the report includes the unique field from the form, then you can use the Where condition of the OpenReport method:
DoCmd.OpenReport "rptName", acViewNormal, , "[UniqueFieldOnReport]=Forms![frmName]![UniqueFieldOnReport]"
If the user has the ability to edit/add a record before printing it, you will also need to save the record.
Copyright & Disclaimer