Get totals from sub report to main report

[Guest]

I have a report with 2 sub reports on them,
Main Report
Sub Report1 contains Fee Totals (A textbox contains this information)
Sub Report2 Contains Payment totals (A textbox contains this information)

On the main report I would like to show a balance due: fees - payments.

This is what I have so far in at textbox on the main form I set the text
field control source to =[sub report1].[Report]!FeeTotal - [sub
report2].[report]!paymentTotals

The text box displays #name? I even tried just displaying the total fees on
the main form as follows: =[sub report1].[Report]!FeeTotal I still get
#name?

Any ideas on what I am doing wrong?
Thanks
ToniS

 

[Allen Browne]

Toni, make sure the Name of this text box is not the same as the name of any
field in the report's source query/table.

More info in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html