Adding sum of multiple textboxes

[qwerty]

I have multiple text boxes, and a text box to display the sum, I have tried this

Sub GetSumOfTbs()
Me.Textbox3 = (IIf(Me.Textbox1 = "", 0, Me.Textbox1) + 0) + (IIf(Me.Textbox2 = "", 0, Me.Textbox1) + 0)
End Sub

It doesn't do anything at all, when I type in a number in the field.

[isladogs]

Your textboxes likely are null not empty strings.
Instead use the Nz function for each control e.g. Nz(Me.Textbox1,0)

BTW You also made a mistake in the second part of your code. Can you see what it is?

[June7]

Are you trying to save calculated value - why?

Could just have expression in Textbox3 ControlSource. And why are you adding 0?

=Nz(Textbox1,0) + Nz(Textbox2,0)

[qwerty]

Nothing is happening ??????

[June7]

You type a number into a textbox? Then do you press Enter or Tab or click somewhere else?

[qwerty]

I am trying to get it, so if enter a number in textbox1. Then textbox3 will update, no button or anything. What is your recommendation?

[June7]

Recommendation already made.

1. expression in textbox3 ControlSource

2. type value into textbox1 or textbox2 then press Enter or Tab or click into another control - focus must leave textbox1 or textbox2.

[qwerty]

Recommendation already made.

1. expression in textbox3 ControlSource

2. type value into textbox1 or textbox2 then press Enter or Tab or click into another control - focus must leave textbox1 or textbox2.

Thank you, but when type 1 and 2 it equals to 12? suppose to be 3

[qwerty]

It is working now...thank you

[June7]

Are textbox1 and textbox2 bound to TEXT type fields?

+ sign is concatenation character left over from old BASIC. If both fields are text type then they will concatenate instead of sum.

Either change the field type or:

=Int(Nz(Textbox1,0)) + Int(Nz(Textbox2,0))

or

=Val(Textbox1,0)) + Val(Nz(Textbox2,0))

or

=CDbl(Nz(Textbox1,0)) + CDbl(Nz(Textbox2,0))