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?
 
Back
Top