Updating fields 1

[itsgoodtobeking]

I have a form showing a table in continuous forms, I have several formulas for different fields to change other fields. Some of the formulas affect more than one field, or may be affected by more than one field being changed.

I am planning on putting all the formulas in a macro and running this.

My problem is, I want to run this macro whenever any changes are made on any of the fields on the form (90% of the fields are affected one way or another). That is why I want to run this on any changes made to any field.

How can I do this effectively?

 

[vbajock]

Look in the help file at the BeforeUpdate, AfterUpdate, OnEnter and OnExit events, which apply to both the fields and the form itself, and the OnCurrent event of the form.
In a nutshell, you put conditional statments in these events that fire your macro in response to these events.