Which Evet Do I Need To Use?

[Chipcom]

Hi

I Have a main form and a subform query and I use subtotals calulations in the subform query.
In the main form I have some fields that assigned to the subtotals calculation of the subform query.
I also did a code that change the forecolor of the values in the main form if thier values exceed the value that I determined.

Now I need to know which evet I need to use in order to implement the forecolor on the main form fields?

I tried the timer event and it works but I didn't love it cause it always runs at every X secounds and I need the code will run once.


Thanks

 

[RuralGuy]

How about conditional formatting?