print form/subform fields from main form?

[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

 

[Duane Hookom]

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.

 

[Guest]

Thank you for the reply and suggestion,

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

Brook

 

[Duane Hookom]

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.

 

[Guest]

Perfect,

Thank you very much.

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.

 

[Guest]

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?!?

 

[Duane Hookom]

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?