Link to home
Start Free TrialLog in
Avatar of Azra Lyndsey
Azra LyndseyFlag for United States of America

asked on

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.
Avatar of chaau
chaau
Flag of Australia image

One of the think to look for is the "Force new page" property for the subreport's detail section
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.
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Azra Lyndsey

ASKER

This did it.  Thank you, all, for your help.
You're welcome.  Please close the thread.
This did it.