#Name? in subreport field

[DarkProdigy]

Hey guys,

I seem to be in a bit of a pickle. I have a subreport embedded in my main report and a second subreport embedded in the first subreport (3 levels). On this subreport, I have a text box in which I do a simple total calculation on which I do a summation of data from the 3 subreport and add that to a single value on the first subreport

Now, when I open the subreport up on its own, the calculation happens flawlessly and I get the value I want

But when I open the main report with this subreport in it, the text box shows "#Name?" where the value should be. Here is my control source for the text box:

=Reports!rptThiefHatch!rptThiefHatchAcc!TheifAccessoryTotal+Reports!rptThiefHatch!ThiefHatchCost

where "Reports!rptThiefHatch!rptThiefHatchAcc!TheifAccessoryTotal" is the summation of the 3rd subreport

any thoughts on why this happens?

Thanks in advance,
Nathan

 

[Rich]

You almost certainly haven't referred to the subReport correctly, open the main report in design view and use the CodeBuilder to obtain the correct syntax

 

[DarkProdigy]

Yes this worked, thanks Rich

But I'm still confused as to why it worked when I opened the subreport on it's own and it didn't when I opened it with the main report