before update after update

[bremensleash]

hello can anybody help me coding this one..

again theres no luck finding the topic in google

i want to update the textbox value automatically without the use of a command button.

like in excel if you put the values

f4 + e4 into e5 it will automatically update can i do it also in access???

 

[boblarson]

Set the control source of the text box to

=Nz(Me.YourTextBoxName1,0) + Nz(Me.YourTextBoxName2,0)

It won't save to the table but then again you shouldn't be storing calculations to the table if you have the components to be able to recreate them in a query, form, or report anyway.

 

[bremensleash]

hello bob where should i put the code in the for

code builder

how to set the control source of my text box?

im sorry i dont know about these terms kindly help me.

 

[neileg]

Open the property sheet for the text box. Open the Data tab. Enter the formula in the ControlSource property.