control source

[Meredith Mcgowan via AccessMonster.com]

In a form, I have the control source as a calculation. I need the value of
that calculation to be recorded in a table. Is this possible?

 

[Rick B]

Why?

When you need that value in a report, query or form, simply calculate it.
Storing it in the table would be redundant if the data used to calculate it
is also there. What if a user changes one of the values? How will the
calculated value be updated?

There are exceptions. If you want to store a calculation at a point in time
(rates change, prices go up, etc.) then there are ways to do so. Post back
with what you aare doing for more details. Are you storing the calculation
in the same table upon which your form is based? Are you requiring
variables from the user that may change? Etc.

Rick B

 

[Meredith Mcgowan via AccessMonster.com]

The calculation will be stored on the same table the form is based off of.
Yes, there are variables that the user inputs (quantity of an item).
I want to store the value in a table so that it can be compared to a value
in another table. For example, quantity of an item is entered into a form,
the quantity is calculated by a $ value and the total of all $ is added in
the final cell (control source). (The formula cells are locked so that a
user can not change the values). I want to compare the control source
value with a value in another table. (which is linked from another database)
.. The two values need to be compared in a query to notate a difference.
Is this possible?