Command button to print report?

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I need to print a command button that will print a report I created. This
report is formatted so that each record is one page of the report. how do I
print only the current record showing on my form to this report?
 
Hi,
Assuming you have a primary key that defines the record, use that as criteria
to a query that your report will be based on.
So in your query you'd have as criteria:
Forms!yourForm!ControlThatHasPK

The drawback to this is that the form must always be open to print that report.
 
Back
Top