calculated text boxes

[#1AccessDummy]

Lets say I have a form called form1 with 2 subforms named subform1 & subform2.

Can I place a text box on form1 that totals fields located on subform1 & subform2?

This is what I currently have as an expression in the text box. It is in the before update event, which may be the problem. Any ideas or solutions are much appreciated.

=[subform1].Form!field1+[subform2].Form!field1

 

[RuralGuy]

Your formula needs to be the Control Source of the TextBox on Form 1.

 

[#1AccessDummy]

worked like a charm, thx

 

[RuralGuy]

You're welcome and thanks for posting back with your success.