displaying calculated value in a textbox

[dfuas]

Hi,

I have a form with a textbox and I want to fill that text box with the calculations from values of other text boxes. However when I put the equation
= Sum (box1 + box2 + box3) into the textbox's control source I don't get any results even though box1, box2 and box3 have values in there.
I also need the result to be saved in a field on my table, but I got no idea how to do it.

Please help!

Thank you
dfuas

 

[ghudson]

Put the code in the forms OnCurrent event, not in the text boxes control source.

txtBox1 = txtBox2 + txtBox3 + txtBox4

You should never store calculations!

 

[dfuas]

Thank you.