Event on parent form after the subform loads ?

[ann06]

hi,


I have parent form and child subform
one field in the parentform is calculated on sum of records on the childsubform
when the parent form loads initially the value in the calculatedfield is 0 then it shows the correct value when the childsubform value is populated
i have anotherfield i want to change the property of the onotherfield.backcolor= RGB(0,0,255) when calculatedfield.value<0

but its taking the initial value(0) not the calculated one
which event shall i invoke on the form so that it waits the subform to complete then fires ... i tried current, load, activate events .. with no success
please help me

[June7]

Try Conditional Formatting instead of code.

[ann06]

Try Conditional Formatting instead of code.

Thank you very much