Textbox control source to field plus Sum

[naminder]

I have a textbox with it's field control source set.

Is there any way of having a Sum function that adds up other textboxes and saves them in this field/textbox.

So far i can either set the control source to the field name or have =Sum([size_sqm])

 

[mhartman]

Hello:
Yes this is possible. For your grand total box just place something link = Text1+Text2+Text3.
This should give you the total of other sums
Regards
Mark

 

[naminder]

Just to clarify

This is in my Control Source property:
=Sum([tbl_rooms.size_sqm])

This sums everything fine.

I need to save the result in the field from the same textbox:
tbl_property_units.size_sqm

something like
=tbl_property_units.size_sqm And Sum([tbl_rooms.size_sqm])