By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Identical subReports - same MAIN: 1 prints data and the others does not.

Share this Question
Share on Google+
11 Replies


PhilOfWalton
Expert 100+
P: 1,430
The implication is that the RecordSource is missing for Suppliment 2.
Check that the query used as the RecordSource runs, and it also contains the field "iRnumber"

You were warned that you would run into problems without normalising your Db

Phil
Jul 4 '18 #2

P: 32
The PRINT function is from a CmdBtn on the FORM. You can see in the Property Sheet that the RecordSource IS the FORM itself, not a query for both but SUP#1 works, SUP#2 does not. The subREPORTS (imported separate REPORTS) are NAMED (subSUP1 and subSUP2) both have the TABLE as the RecordSource As indicated, both #1 and #2 have data as follows;



I cannot seem to find a DIFFERENCE between #1 (works) and #2 (does not work)that would cause the issue.
Jul 4 '18 #3

PhilOfWalton
Expert 100+
P: 1,430
Please try to be very accurate with information supplied. Long posts in other threads have been caused by things not being correctly identified.

"You can see in the Property Sheet that the RecordSource IS the FORM itself" makes no sense to me at all.

You should have a Query or Table as the RecordSource of your Main Report and both Sub Reports. Those three Queries / Tables should contain the linking field - iRNumber.

It is most likely that the main report should open & show data (for the moment, ignore the sub reports)

Both sub reports should open in print preview (NOT on the main report), and show data.

Does this happen?

Phil
Jul 4 '18 #4

P: 32
The 1st & 2nd images in the original post, have part of the Property Sheet showing with each for comparison, my mistake ... I should have said "SOURCE OBJECT". The MAIN REPORT and both subREPORTS have the same TABLE as their source .... all have the "IRnumber" field in common.

A new discovery on testing is this: MAIN and subSUP1 work correctly in all views and print. subSUP2 is ONLY VISIBLE in DesignView .... totally blank sheet in Report View and Print View.
Jul 4 '18 #5

PhilOfWalton
Expert 100+
P: 1,430
There is obviously something the matter with the RecordSource of SubSup2.

Please send an image in design view with the property sheet on the "Data" Tab.

Phil
Jul 4 '18 #6

P: 32
From both SECTIONS on the MAIN Report;

Jul 4 '18 #7

NeoPa
Expert Mod 15k+
P: 31,186
Phil:
Please send an image in design view with the property sheet on the "Data" Tab.
You may want to try that one again.
Jul 4 '18 #8

PhilOfWalton
Expert 100+
P: 1,430
@Neopa

There was so much confusion on another post about tabs, and I can't get answers on this post.

Regretfully, unless we get the information asked for, I am going to bow out.

Phil
Jul 4 '18 #9

NeoPa
Expert Mod 15k+
P: 31,186
I hear you Phil.

In this case I suspect that MMinieri is trying, but struggling to deal well with the detail - possibly across a language barrier. I recommend giving them a bit of leeway, but it's always your call of course.

They've not long since posted their last one and could be a while before seeing and/or replying. Hopefully more on point now that's been drawn to their attention.
Jul 4 '18 #10

P: 32
[SOLVED] On the MAIN REPORT, for each SUB-REPORT, the SOURCE OBJECT was set to the FORM that initiated the PRINT. Changed these Source Objects to the corresponding SUB-REPORTs and works. Thanks again for struggling with my ignorance. On to the next hurdle.
Jul 5 '18 #11

twinnyfo
Expert Mod 2.5K+
P: 3,063
Glad that all were able to come together and provide some advice.

Access is a life-long learning project. Hope you continue to endure!
Jul 5 '18 #12

Post your reply

Sign in to post your reply or Sign up for a free account.