Add Code needed!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob V - 12 Sep 2007 23:35 GMT

-
-

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

Reply to this Message

KARL DEWEY - 12 Sep 2007 23:52 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> -
> -
>
> 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

Reply to this Message

fredg - 12 Sep 2007 23:52 GMT

> -
> -
>
> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message