Access database form printing problem.

Got this from a friend.  I've not used Access in years and Google doesn't seem to be giving me the answer:

I'm working on an Access database with a form and subform that feed into a report and subreport. I've put a print button into the form to be able to print the current record, along with the corresponding records in the subform. The problem is that the report prints multiple identical pages - one page for each subrecord, even though they are all listed on every page. I'm trying to get it to just print one page.
LVL 1
Azra LyndseyNerdAsked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
When you use a main report/subreport or main form/subform, the main form/report is bound to the parent table or query thereof and the subform/subreport is bound to the child table or query thereof.  Your problem sounds as though the main report's RecordSource includes a join to the table for the subreport and so you are returning a main report record for every subreport record when there should be only one main report record.
1
 
chaauCommented:
One of the think to look for is the "Force new page" property for the subreport's detail section
0
 
hnasrCommented:
Is it printing one main record?

If a subreport is linked to a main report, it should print main record, and then lists all related subrecords as per design. In general, by default, no force of new pages.

If you can, reproduce the issue with a simple demo database.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Azra LyndseyNerdAuthor Commented:
This did it.  Thank you, all, for your help.
0
 
PatHartmanCommented:
You're welcome.  Please close the thread.
0
 
Azra LyndseyNerdAuthor Commented:
This did it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.