Solved

Access database form printing problem.

Posted on 2016-08-11
6
62 Views
Last Modified: 2016-08-21
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.
0
Comment
Question by:Azra Lyndsey
6 Comments
 
LVL 24

Expert Comment

by:chaau
ID: 41753384
One of the think to look for is the "Force new page" property for the subreport's detail section
0
 
LVL 30

Expert Comment

by:hnasr
ID: 41753580
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
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41753907
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 1

Author Comment

by:Azra Lyndsey
ID: 41764700
This did it.  Thank you, all, for your help.
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 41764704
You're welcome.  Please close the thread.
0
 
LVL 1

Author Closing Comment

by:Azra Lyndsey
ID: 41764714
This did it.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question