Sum Unbound Text Boxes

[pd2222]

I have created a new form, inserted 4 Unbound text boxes. In the 4th box I have inserted in the control source:

=Sum([Text1]+[Text2]+[Text3])

Why won't the above work??? Is it because they are unbound boxes??

Please help!

KG

 

[JDettman]

Actually, because you used SUM(), which is used in conjunction with SQL and queries. So yes, it only works on bound controls. Instead do this:

=[Text1]+[Text2]+[Text3]

Jim.

 

[pd2222]

Hi,

Cheers for your suggestion which I tried but it didn't actually add them together it just concatenates them. Does this mean I have to admit defeat. All I want to do is have a form which can perform calculations like a calculator!!

Keza

 

[DJN]

I assume it has concatenated them because they are strings? if so convert the strings to numeric.

Private Sub Text4_AfterUpdate()
[SumTextBoxName] = Val([TextBox1]) + Val([TextBox2]) + Val([TextBox3])
End Sub

Place the code in the after update event of the last text box before the 'sum' textbox

David

 

[tempclerk]

Actually, I would put the code in the After Update of Each textbox unless you want to go through the trouble of clearing or hiding the total until each textbox in turn has been filled.