Change in calculated control value to run event procedure?

T

Tec92407

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
 
J

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
Click to expand...

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]
 
Top