Acc 2010 having problem putting with total of hours on main form, from sub form

[DougP]

Getting #Error with eveything I try,
I want to get the total of hours for whatever records show in the subform.
I have tried adding a total box to the subform detail which works in the subform but on the main form it does not. gives #Error
added a total box to page footer on subform
here is the conrol source on the main form text box.
=Sum([Forms]![frmManagerApproval]![TimeReporting subform1].[Form]![Hours])


DougP

 

[PHV]

a total box to the subform detail which works
Name of the total box, the subform's control and the main form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886