UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Main Form With 6 Tabbed Subforms Printing Problem, Access 2013    
 
   
rvhill2014
post Apr 19 2017, 11:37 PM
Post#1



Posts: 4
Joined: 18-May 14



I have a main form with 6 sub-forms in a tab control box. Parent to Child link is based on what i call "TestNo" (for test number). This field is on each of the 6 sub-forms and is linked to the mainform. My problem is that when i try to preview and/or print a report, I get 6 copies of each report (the same number of tabs). The reports are filtered by the name of the Main form, "testno" field. The reports were created using the main report with sub-reports representing the different tests .. again linked by "testno" field. Any help would be appreciated.
Go to the top of the page
 
mike60smart
post Apr 20 2017, 10:04 AM
Post#2


UtterAccess VIP
Posts: 12,176
Joined: 6-June 05
From: Dunbar,Scotland


Hi

Can you upload a zipped copy of the Db so we can see the structure??


--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
jwhite
post Apr 20 2017, 11:25 AM
Post#3


UtterAccess VIP
Posts: 5,801
Joined: 31-August 06
From: North Carolina, USA


Can you post the RecordSource for the main report for us to see?

--------------------
Go to the top of the page
 
rvhill2014
post Apr 20 2017, 10:19 PM
Post#4



Posts: 4
Joined: 18-May 14



I'm not sure how to extract parts of my DB , so I put some screen shots in a PDF.. Hope you can understand it.

Thanks in advance for your help.Attached File  Private_Sub_Command33.pdf ( 580.1K )Number of downloads: 6
Go to the top of the page
 
projecttoday
post Apr 20 2017, 10:33 PM
Post#5


UtterAccess VIP
Posts: 8,285
Joined: 10-February 04
From: South Charleston, WV


Is this a new report you're developing or has it worked correctly before? Did you try compact and repair? You're getting 6 distinct separate copies of the same report. What happens when you run the report's query. At the risk of insulting your intelligence, are you sure it say '1' in the copies field of the print popup?

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th August 2017 - 04:24 AM