2 subreports in unbound main report

[goestejs]

I have a database for facilitating defective material notifications and chargebacks to our suppliers. The 1st report contains information about the supplier, material and chargeback info (This report also contains to subreports related to the chargeback info). The 2nd report contains the shipping documents that will travel with the material to be returned to the supplier. Both reports function properly when run individually, however, when I place them in an unbound main report, some of the values on the 1st report show #Name?. I have scoured forums for a resolution to this problem, but cannot find a solution that works.

 

[dhookom]

We can't see your reports. Can you tell use the control sources and report sections where "some of the values on the 1st report show #Name?"

Duane
Hook'D on Access
MS Access MVP

 

[goestejs]

I was able to achieve the desired results by placing the 2nd report contains the shipping documents that will travel with the material to be returned to the supplier into the report footer of the 1st report contains information about the supplier, material and chargeback info instead of placing them both in an unbound main report.