total a column of text boxes on a form

S

Shari

I have 12 text boxes in a column that I would like to do a running total on.
As someone enters in an amount I would like the total textbox to reflect the
new amount

Thank you
 
H

hmadyson

Create a new text box on the form that is unbound. Set the controlsource =
[field1]+[field2] + ..... This should automatically update. If it does not,
then add VBA code to the afterupdate event of each field to refresh the
field.

You may need to use conversion functions on that textbox if the fields are
not bound to fields in a table. These would be functions like cint() or
cdbl().

Please let me know if this was helpful and if I can be of more assistance.
 
Top