Calculated data in text box update to table?

[allcarfan]

I have a textbox on a form that displays a calculated number with regards to input from other text boxes.

I need this calculated number to update to a corresponding field within a table.

I have a button that updates the information, but the calculated field will not update.

I have an "=" expression written that does all of the calculating. When I put this in the 'control source' it calculates and displays on the form perfectly, but will not update the table. If I change the control source to the field within the table and then move the "=" statement/expression someplace else....the field is blank on the form, but I can manually input a number and it will update to the table.

Follow?

 

[ansentry]

My advice never store calculation in a table. You will get errors.

Use queries or text boxes on a form and let access calculate it each time the query runs or the form is opened.


Do a search in the forum about calculation in tables