Print Subform Table (1 Viewer)

[SierraJuliet]

The following are the element(s): Form, Sub Form, Table

The form contains the subform that populates the table record(s) based on a query.

What is simplest method for printing all the record(s) of the table that populates the subform from a query.

Form: frmViewTools
Subform: subfrmQueryCustom
Table: tbl*

 

[Gasman]

Use the same source?

 

[Ranman256]

a report, using the same query in the subform.

 

[Pat Hartman]

If the subform is connected to the mainform using the master/child links, you need to add that filter when you run the report. Use the Where argument of the OpenReport method.