Print Report Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 2 forms that are used in a form/subform relationship. I would like to put a button on the subform to print a report for only that one particular record. Can you offer some assistance

Thanks
 
The command button to print the report should be on the main form, which
links to the subform automatically per the Master/Child relationship. Create
a macro for the OnClick event of the command button. Name the macro
something like "Print Single Report....." The macro's Action is OpenReport.
In the bottom section of the macro select the report name and view (print or
print preview). In the Where Condition enter the following:
[Client ID]=Forms![Name of Your Form]![Client ID]

Of course you should replace [Client ID] with the actual field name that
represents the unique record to print.


Jon said:
I have a 2 forms that are used in a form/subform relationship. I would
Click to expand...
like to put a button on the subform to print a report for only that one
particular record. Can you offer some assistance?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing a report from Form and Subform 1
Filter Report by Subform Records 4
Help! Report Printing Multiple Records from Subform 2
Access Access Report Works on One Machine but not Another 3
Errors in Report total fields 19
Runtime Printing Problem 2
Command Button to Preview/Print Report 4
Two Criteria 3

Back
Top