Change in calculated control value to run event procedure?

[Guest]

I have a calculated control on a main form that displays a Totals number.

It is calculated from two field values on a subform.

I want to run an existing event procedure in the main form when the Totals
value changes.

Is there a way to do this?How?Suggestions?

thanks

 

[John Vinson]

I have a calculated control on a main form that displays a Totals number.

It is calculated from two field values on a subform.

I want to run an existing event procedure in the main form when the Totals
value changes.

Is there a way to do this?How?Suggestions?

thanks

Use code in the AfterUpdate events of each of the controls upon which
the total is based. There aren't any events that fire when a
calculated field changes.

John W. Vinson[MVP]