printing from a form

[Bob]

I have a form with a subform.
I would like to print a report that is linked to a field in the main form
and a field in the sub form

example
main form
tblCustInfo
custID
Name
etc ......
Sub form
tblInvoice
custID
InvoiceNum
etc ......

The report I want to print out will print out information based on a query
linking both tblCustomer and tblInvoice. If I print out the query, I print
out all the records. I just want the one record for the customer the user
has on the form.

 

[Allen Browne]

Use the WhereCondition of the OpenReport to limit the report to the
InvoiceNum in your form.

Details in:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html