Reference main report on a subreport

[Gitche Gumee]

I've read everything here that I think might apply, but still can't make this
work.

I have a subreport in a section footer. In the subreport I have a text box
that I want to set to the value of a control in the section header on the
main report. Using Control Source "=Reports!MainReport.textbox" gives me a
#Name? error. Using Control Source "=textbox" gives me a value but it repeats
the same value for every record in the subreport instead of the actual value
of the textbox in the main report header.

What do I have to do?

 

[NetworkTrade]

try
=Reports!MainReport.Report!textbox

 

[Gitche Gumee]

Perhaps I'm referencing correctly but I'm not getting the data I want.

The setup is:

Dept Header
Project Header
Detail
Project Footer
Dept Footer

I want a summary in the Dept Footer that will list all the projects in the
dept and show a specific counter from the detail section of each project.

So the summary should be:
Project A Counter A
Project B Counter B
Project C Counter C

What I'm getting is:
Project A Counter C
Project B Counter C
Project C Counter C

I've tried putting this counter in the Project header as well. I get the
same incorrect results.