Printing report from Form with Subforms

[jasonrbaxter]

I am trying to make a report that has two subforms print a single
record or multiple depending on how many subforms are included in the
form


My main table is called Equipment


My two subtables are called Problem and Resolution


I saw this link that was posted previously:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209560#appliesto



This doesn't apply to printing a single record that may have multiple
subforms included.


If this doesn't work I wanted to use our existing Word document and use

mail merge to take the main form along with the subforms into Word with

all the blanks filled in.


Thank you in advance.

 

[John Vinson]

I am trying to make a report that has two subforms print a single
record or multiple depending on how many subforms are included in the
form


My main table is called Equipment


My two subtables are called Problem and Resolution

This is not an issue of "how many subforms". There are always two
subforms. They may or may not be displaying data from the Problem and
Resolution table, but your Report is printing data from the tables -
not the subforms!

I think what you need is a Query joining Equipment to Problem, and
Equipment to Resolution. In each case select the Join line and choose
option 2 - "Show all records in Equipment and matching records in...";
this will let you include an Equipment record on the report, whether
or not there are matching records in the other two tables.

John W. Vinson[MVP]