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

[mminieri]

LARGER VIEW - http://www.minieriassociates.com/Print_Anomaly_1.jpg

[PhilOfWalton]

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

[mminieri]

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.

[PhilOfWalton]

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

[mminieri]

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.

[PhilOfWalton]

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

[mminieri]

From both SECTIONS on the MAIN Report;

[NeoPa]

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

You may want to try that one again.

[PhilOfWalton]

@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

[NeoPa]

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.

[mminieri]

[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.

[twinnyfo]

Glad that all were able to come together and provide some advice.

Access is a life-long learning project. Hope you continue to endure!