Subtotal from subreport on main report

[mattc66 via AccessMonster.com]

I am having trouble getting the subtotal from a sub report on my main form.

On the subReport in the page footer I have the following:
ReportName: rptSubOrderDetailList
ControlName: txtExtListPrice
=Sum([ExtListPrice])

On my main Report
ControlName: txtSubTotal
=rptSubOrderDetailList.Report!txtExtListPrice

I am getting #Error when I view the report.

 

[Marshall Barton]

I am having trouble getting the subtotal from a sub report on my main form.

On the subReport in the page footer I have the following:
ReportName: rptSubOrderDetailList
ControlName: txtExtListPrice
=Sum([ExtListPrice])

On my main Report
ControlName: txtSubTotal
=rptSubOrderDetailList.Report!txtExtListPrice

I am getting #Error when I view the report.

First off, you can not use Sum in the Page Header/Footer
sections, use the Report header/Footer instead. Second,
page header/footers (and the Page event) are ignored in
subreports.