referencing textboxes on subreports

[slames]

I have 2 subreports in a report. I need to refer to the total field from each of these and show the total payable. When I use the following syntax it doesn't seem to recognise the field.
Report!ReportName!FieldName.

Can anyone help?

Thanks
Steph

 

[dhookom]

The correct syntax should be:
=SubRptControlName.Report.txtTextBoxName
If there is a chance that the subreport will not have any data, then this will not calculate properly. You would need syntax like:
=IIf(SubRptControlName.Report.HasData, SubRptControlName.Report.txtTextBoxName,0)


Duane
MS Access MVP

 

[slames]

Thanks, I've got that working now.