Automatic Sum Updates

[Tom Bock]

On a form, does anyone know how to automatically update a textbox that
displays the SUM of multiple textboxes.

For instance, I have Box1 and Box2. Box1's value is 5; Box2's value is 3.

The BoxSum automatically displays 8 right now. However, if I were to
change any of the values (e.g. 5 to 4 for Box 1) then the BoxSum does not
automatically gets updated.

I tried to put an AfterChange event into Box1 and Box2 with the following
code:

BoxSum.Requery


However, this still does not work. Any suggestions?!?

Thanks,
Tom

 

[Joe Fallon]

Did you try this for BoxSum:
=[Box1] + [Box2]

 

[Tom]

Joe:

PERFECT! That works great!!!



--
Thanks so much for the info,
Tom

Did you try this for BoxSum:
=[Box1] + [Box2]
--
Joe Fallon
Access MVP

On a form, does anyone know how to automatically update a textbox that
displays the SUM of multiple textboxes.

For instance, I have Box1 and Box2. Box1's value is 5; Box2's value is 3.

The BoxSum automatically displays 8 right now. However, if I were to
change any of the values (e.g. 5 to 4 for Box 1) then the BoxSum does not
automatically gets updated.

I tried to put an AfterChange event into Box1 and Box2 with the following
code:

BoxSum.Requery


However, this still does not work. Any suggestions?!?

Thanks,
Tom