Keith Registered User. Local time Today, 10:52 Joined May 21, 2000 Messages 129 Jun 14, 2000 #1 I have a print button on a form that I want to use to print a report with only the data from the current record on the form. Can anyone help please? Keith
I have a print button on a form that I want to use to print a report with only the data from the current record on the form. Can anyone help please? Keith
R Robert C Registered User. Local time Today, 10:52 Joined Mar 27, 2000 Messages 88 Jun 15, 2000 #2 I had the same problem and a guy called Neal posted the code below which I have used very effectively. It should go in the On Click event DoCmd.OpenReport "yourReportname", acPreview, , "[UniqueIdFieldName]= forms!yourFormName!UniqueIdFieldName]"
I had the same problem and a guy called Neal posted the code below which I have used very effectively. It should go in the On Click event DoCmd.OpenReport "yourReportname", acPreview, , "[UniqueIdFieldName]= forms!yourFormName!UniqueIdFieldName]"
