How do I automatically up date a field in another table based on .

[Guest]

How do I automatically up date a field in another table based on the info I
have just entered and saved in a table in a form?

 

[Allen Browne]

You could Execute an Update query statement in the AfterUpdate and
AfterDelConfirm events of the form where you saved the changes.

The more important question might be whether this is a good idea. In
general, you do not want to store a calculated total or anything where the
result depends directly on other values in the database. Instead, you want
to calculate that value at the time when you need it, so it can never be
wrong.