#Error displayed in text box on report
I have a subreport [PackSlipDtl] that displays line item values. [TotValue]
In the subreport footer, I have a text box [txtSumTotValue]to calulate the total of the line items. The control source is set to =Sum([TotValue]).
On the main report, I have a text box to display the Sum and the control source is set to PackSlipDtl!txtSumTotValue
When I run the report, the text box on the main report displays #Error.
Can someone help with this?
Thanks .... Ray