help needed - getting errors on form/record change

[martinr]

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 on the form is based on the values of the current record (eg a negative value will change font to red).
The code works fine when a new record is entered or the 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 event procedure?

 

[John Big Booty]

First up Welcome to the forum.

Secondly I will direct your attention to this thread and counsel you to read it prior to making further posts.

Lastly further multiple postings are likely to be construed as SPAM, be warned.