Table not updating from the form

[fred]

I have created a form based on a table. The form provides drop down
selections for some fields. All of the data entered or selected shows
up in the table except for one form field that is a calculated value.
I cannot make the calculated data show up in the table.

I will do a report and query for the results I need, but what am I
doing wrong that the table does not update for this one field only.

 

[fred]

The thing that causes a control to store its data in the table is having a field
name as its ControlSource. If it has a ControlSource that is an expression
performing a calculation then it is not bound to a field and therefore the value
is not saved to the table.

Now for the good news. You are not supposed to store calculations anyway. Just
eliminate the field from the table and use the expression you now have any place
you need it. If you only want to write it once then create a query based on
your table and add the expression as a calculated field in the query. Then
simply use the query in all places where you would otherwise use the table and
the value will be there for you.

Thank you Rick. My level of frustration just went way down.