How to populate these columns?

[Dorian]

I have a form bound to my table and a subform for a related table. The main
form contains two calculated controls TotalPaid and BalanceDue. These
controls are unbound and are calculated based on the contents of the subform
and other controls on the main form. I'd like the contents of these two
controls to go into hidden bound controls to populate columns in the main
table. My question is what event to do this in. The control source for the
calculated controls is set in the Current Event. Would the BeforeUpdate event
be the one?
Yes, I know its not correct to have calculated values in my table but that
is the way it was designed and I cannot change it. Thanks.

 

[Rick Brandt]

I have a form bound to my table and a subform for a related table. The
main form contains two calculated controls TotalPaid and BalanceDue.
These controls are unbound and are calculated based on the contents of
the subform and other controls on the main form. I'd like the contents
of these two controls to go into hidden bound controls to populate
columns in the main table. My question is what event to do this in. The
control source for the calculated controls is set in the Current Event.
Would the BeforeUpdate event be the one?
Yes, I know its not correct to have calculated values in my table but
that is the way it was designed and I cannot change it. Thanks.

BeforeUpdate is the correct event.