macro to run automatically when a field is updated

[TheRoundPen]

I have two form fields on an employee appraisal form. One calculates a grand
average score from four different scoring areas on the form. The second field
evaluates this score (using a macro) to determine the increase percentage
based on the grand score. This macro is assigned to the field to run on
entry.

My problem is that if an evaluator goes back through the form and changes a
score, they must click in this percentage field to get it to update to the
correct value.

My question is: how could I make this field update automatically anytime a
change is made anywhere on the form?

Thank you for ANY assistance you can give!

 

[macropod]

Hi TheRoundPen,

So why not call the macro via to 'on exit' property of the fields concerned? If necessary, you could incorporate a test in the macro
to exit without doing anything if some condition (eg some of the scores have not been entered) isn't met.