Command button to print report?

[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?

 

[Dan Artuso]

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.