Adding text boxes

[thusnani@gmail.com]

Im trying to add
txtBox1 + txtBox2 + txtBox3 + txtBox4 + txtBox5 + txtBox6 + txtBox7 +
txtBox8 + txtBox9 + txtBox10 = txtBoxTotal
Now im to write some code so everytime i enter a number into a text box
it will give me a running total in txtBoxTotal. What i'm having
problems with is when the rest are null i get errors and the total
doesnt come up in the bottom.
Please let me know if anyone can help.
Thanks

[fredg]

Re: Adding text boxes

On 18 May 2006 12:01:50 -0700, thusnani@gmail. com wrote:
[color=blue]
> Im trying to add
> txtBox1 + txtBox2 + txtBox3 + txtBox4 + txtBox5 + txtBox6 + txtBox7 +
> txtBox8 + txtBox9 + txtBox10 = txtBoxTotal
> Now im to write some code so everytime i enter a number into a text box
> it will give me a running total in txtBoxTotal. What i'm having
> problems with is when the rest are null i get errors and the total
> doesnt come up in the bottom.
> Please let me know if anyone can help.
> Thanks[/color]

look up the Nz function in VBA help.
txtBoxTotal = Nz([Text1]) + Nz([Text2]) + Nz([Text3]) + etc.

The value in txtBoxTotal should NOT be stored in any table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail