Referencing calculated text box on subreport

[ChallengeFun]

I have read through old posts regarding referencing calculated fields in subreports using either a direct reference (=reports.[reportName].[CalcFieldName]) or a Hasdata reference, but I find no solution to my present dilemma. My problem, I think, is that I want the unbound control that is referencing the subreport calculation to appear in the Page Footer of the main report. Either a direct reference or a HasData function will work on this if the unbound control appears in the group footer or detail section. Is there something in A2k that prevents this procedure from being possible within a Page Footer, or is there something I am missing? I have also tried placing the unbound control in the group footer, making it invisible, and creating another unbound control to reference that control for placement in the page footer...nothing has worked.

Ultimately, I'm trying to create footnotes to records in the report...I've been working on this off and on for weeks, and found no solution - any advice is much appreciated. If I need to supply more specific info, lmk.
Thanks

 

[RobertScott]

try this

I had a similar problem referencing controls on a subreport from a main report.
I was trying to reference the control like this:

=[Report]![ReportName]![ControlName]

But I found that was incorrect and found out that it needed to be referenced this way instead:

=([NameOfSubReportControl].[Report]![NameOfControlOnSubreport])

Scott