print form/subform fields from main form?

B

Brook

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
 
D

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.
 
B

Brook

Thank you for the reply and suggestion,

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

Brook
 
D

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.
 
B

Brook

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.
 
M

Michelle K

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top