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. Top   HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES E-MAIL Copyright & Disclaimer

Last modified at 06/06/2006 15:00:53