getting calculated values from form to table

[Guest]

I have a number of values that I am calculating in a form and would like the
calculated values to be input into fields of the corresponding table. I have
written the formulas into the control source of the boxes (I dont know the
technical name for these) on the form, so the calculated values show up on
the form, but they do not get added to the table. Is there some other place
I should be putting the formula and then just putting the name of the field
in the table where I want the calculated value to go into the control source
on the form?

 

[Guest]

It is normally not considered to be appropriate to store calculated values.
Just calculate them anytime you need them. This way if the data that was
used to calculate the value changes, the calculated value will reflect the
changes. If you store the values, the values might not be updated and
therefore wourld be incorrect.

To answer your question, just select the appropriate field where you want
the calculated value to be stored in the "Control Source" property of the
control. This will cause the calculated value to be stored in the selected
field.

 

[Rick B]

You don't store calculated values in a table. What if one of the fields
upon which the calculation is based changes? Then your calculation would be
wrong.

Store the numbers that are used in the calculation, then calculate in your
forms, queries, or reports.

This is a pretty common question. Read the previous posts if you need more
detail.

 

[Larry Daugherty]

It sounds like it's working exactly as it should. You should never
store calculated values back into the database. Synchronization
errors can and will arise. Instead, calculate that value each time
you need to present it.

HTH