If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing report from Form with Subforms
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...9560#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. |
#2
|
|||
|
|||
Printing report from Form with Subforms
On 7 Dec 2005 07:18:59 -0800, "jasonrbaxter"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Is There a Macro Command to Refresh Form Before Printing Report?? | [email protected] | Using Forms | 2 | May 21st, 2005 08:26 PM |
Is it possible to show both "Yes" and "No" answers from a "yes/no" checkbox? | Colin Foster | New Users | 28 | March 18th, 2005 02:19 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |