Add Code needed!

[Bob V]

-
-

If I have four text boxes on my form tbA,tbB,tbC,tbD what code do I need for
tbD to add the other three totals into tbD
Thanks for any help.....Bob

 

[Guest]

Use source like this ---
=NZ([Control_Source_of_tbA], 0) + NZ([Control_Source_of_tbB], 0 ) +
NZ([Control_Source_of_tbC], 0)

 

[fredg]

-
-

If I have four text boxes on my form tbA,tbB,tbC,tbD what code do I need for
tbD to add the other three totals into tbD
Thanks for any help.....Bob

As the control source of [tbD], write:

=Nz([tbA])+Nz([tbB]) + Nz([tbC])

The result should NOT be stored in any table.
When ever you need the calculated total, re-calculate it as above.