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
