inserting calculations into a field in forms

R

Rachel

Hello. Can anyone help me? In a form that I've made, I have a field where a
calculation is made from other fields. I want to store the results of this
calculation back into the table but I don't know how to do it.
I put the calculation into the 'default value' setting in properties and
then put the control source as the field where I want it stored, but the form
field appears blank.

I'd really appreciate any advice or guidance.

Thankyou very much,
Rachel
 
A

Allen Browne

Default Value is too early. Access processes that before your other fields
have their values.

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains when to store calculated results, how to do so (using
the AfterUpdate event of each control), and how to have Access give you
results without storing them when this will have you lots of issues (using
queries.)
 
R

Rachel

Thankyou SO much for such a quick and helpful reply. I've been struggling for
days with this and appreciate your help so much!
Thanks again,
Rachel
 
K

Korski

I'm running into the same issue as Rachel, The reason it would be helpful
to store a calculated value and not the component would be for purposes like
lab work. Ex) We measure sample pieces several times to get an average
thickness. We will never again use the individual thickness
measurements........just the final average. Maybe this is is similar to
Rachel's need.
 
Top