print form/subform fields from main form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following:

frminvoices
frminvoicedetails subform
frminvoicepayments subform

I would like to print the current record including fields from the main form
and subforms?

Any suggestions?

Thanks in advance..

Brook
 
Create a report with two subreports. These should match your forms very
closely. Then open your report with a where clause using the primary key
value from your invoice table.
 
Thank you for the reply and suggestion,

I have never created a subreport? How do I do that?

Brook
 
About the same way you create a subform. Create a report that contains the
information you would like to display. Use the subreport control to insert
the subreport on your main report. You may need to set the Link Master/Child
properties as they are set on your form/subform.
 
Perfect,

Thank you very much.

Brook

Duane Hookom said:
About the same way you create a subform. Create a report that contains the
information you would like to display. Use the subreport control to insert
the subreport on your main report. You may need to set the Link Master/Child
properties as they are set on your form/subform.
Click to expand...
 
I've tried doing this but i am running into these issues:
1. the data on the subform isn't showing;

2. even if i create the join between the mainform and the subform to be a
one to many, it still multiplies all the records on the mainform to how many
records there are in the subform causing a bizzilion page report that is
supposed to be just one page.

help?!?
 
It sounds like your main report still contains a level of record details
that should be removed.

Are you really referring to form/subform or do you mean report/subreport?
 
Back
Top