Report and a sub Report

[rann]

Hi,
I have a Subreport(rptSubReport) on a main report(rptMain).I use the Report to calculate the Number of
course credits for each term and Year.

In my SubReport i use a Sum Function to calculate the
# of credits. Then i need to pull the final total value
to the main Report.I used
"=[Reports]![rptMain]![rptSubReport]![txtTotal]"
but was getting an error.This worked fine for
a form(with a sub form).

Any help will be appreciated,

Thanks in Advance,
Rann.

 

[Lozere]

As far as I remember you missed a field in your expression
Try to change:
"=[Reports]![rptMain]![rptSubReport]![txtTotal]"
to
"=[Reports]![rptMain]![rptSubReport].Report.[txtTotal]"

Check in the Access help if I'm correct.