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

You are not using the right bang dot syntax.

Open the Northwind database, and check the invoice. You need to refer to the subform as an object within the main form. Northwind uses:

=[Orders Subform].Form!OrderSubtotal


Did that help?

mmcdonal

Thanks for the help. That worked. .... Ray

I was under the impression the bang ! was obsolete and that Access works with all dots now. The dot also invokes autotext completion while writing VBA whereas the bang does not.

I do know it still works in VBA, but is it still useful and/or necessary? I don't have bangs in any of my databases. All run quite well.