Nothing would print if subform has no data

[Moe]

My "Order" form has a subform. When I print a report (invoice) from this form
if the subform is blank then the entire report is blank too. Nothing from
other fields that are in the main form (customer name, orderID,...) shows up
in the report. If there is at least on item in the subform then everything
works fine. How can I solve this issue?

 

[John W. Vinson]

My "Order" form has a subform. When I print a report (invoice) from this form
if the subform is blank then the entire report is blank too. Nothing from
other fields that are in the main form (customer name, orderID,...) shows up
in the report. If there is at least on item in the subform then everything
works fine. How can I solve this issue?

It sounds like your Report is based on a query joining the mainform's
table (Invoices) to the subform's table (InvoiceDetails...??). The
default join type is an Inner Join, which will display only those
records with data in both tables.

Open the Query in design view, and doubleclick the join line. Choose
option 2 (or maybe 3) - "Show all records in Invoices and matching
records in InvoiceDetails". Save the query and see if that doesn't
help.

John W. Vinson [MVP]