Help needed with error of form/record changes

[mrl]

Help! I need some text boxes on my form to update their formats/values based on the data in the 'current' record. The formatting of some of the controls is based on the values of the current record (eg a negative value will change font color to red).
The code works fine when a new record is entered or current record is edited, so i tried putting the code into the form's event procedures (like current) which detect a change to the record - but this is causing various errors eg; "the expression you entered refers to an object that is closed or doesn't exist"...
Where should i should be placing the code/event procedure so it works?

[pdebaets]

In virtually every one of my bound form modules I create a "SetControlProperties" sub procedure. This routine I call from the form OnCurrent and certain control AfterUpdate event procedures. It is a good idea to place your formatting code in such a sub procedure so you don't have to duplicate your code in different places.

Regarding your error, what line of code is highlighted when you get the error?