Printing Current Record in a Form as a Report

[LilBomShl]

Can I put a command button on a form the will Print Preview a Report of that
current record showing in the form?

 

[Damian S]

Hi LilBomShl,

Yes, you can. Set the query powering the report so that it picks up the ID
of the record off the form, like this:

select * from TABLENAME where IDFIELD = forms!FORMNAME.IDFIELDNAME

Then use the following in the on click event of the command button:

docmd.openreport "REPORTNAME", acViewPreview

Hope this helps.

Damian.

 

[Ofer Cohen]

Check this link on "Printing the Record on the Microsoft Access Form to a
Report"

http://www.databasedev.co.uk/report_from_form_record.html


**** That way you can print the report from different forms if you need to
and you are not fixed on one form only **

 

[LilBomShl]

Thank you!!

LiL

Hi LilBomShl,

Yes, you can. Set the query powering the report so that it picks up the ID
of the record off the form, like this:

select * from TABLENAME where IDFIELD = forms!FORMNAME.IDFIELDNAME

Then use the following in the on click event of the command button:

docmd.openreport "REPORTNAME", acViewPreview

Hope this helps.

Damian.

 

[LilBomShl]

Thank you!!

Check this link on "Printing the Record on the Microsoft Access Form to a
Report"

http://www.databasedev.co.uk/report_from_form_record.html


**** That way you can print the report from different forms if you need to
and you are not fixed on one form only **