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.