Forms

[AFKAFB]

I've a form which is bound to a table - on the face of the form it
sometimes returns calculated results. However, i also need to record
the calculated result on the table too.
What i've been doing is running an update query when the form unloads
but there must s more correct way of doing this.

 

[tina]

well, there really isn't a "correct" way, because saving calculated data to
a table violates data normalization rules. as long as you have the base
values saved as hard data, you can run the calculations anytime you need
to - in a query, form, or report.

if you're going to do it, regardless, then an update query is as good a way
as any.

hth