Posting data from one subreport on another

[melaniecarr23]

I have two subreports on a main report called plans_report, one is dd_report and one is coins_report.

On dd_report I have a control which is a calculated field named 2005overflow

I posted this value in the main report footer, and named it year1overflow.

I tried referencing this value in the coins_report, but keep getting #Error instead of the value I want to show up.

What am I doing wrong?

 

[THWatson]

Melanie
The #Error would indicate an incorrect reference.

In your coins_report you could try...
Forms![plans_report]!year1overflow

Or
Forms![plans_report].Form![dd_report]!2005overflow

Tom