Form_current event is not working in my case!? Can anyone help me out?

[sweetflea]

i am a newbie but feel like i have tried absolutely everything i know!

on my form, each record has 5 textboxes 'attached' to it which changes colors (red, yellow, green) depending on the data of that particular record.

with the code in the Form_Current event it works fine, AS long as only 1 record is displayed on a page at a time! I need to display many records at a time, and what happens is ALL the records' boxes turn exactly the same as the current record!

any suggestions o' wise ones?

 

[JoeMiller]

Try this web page:

http://www.mvps.org/access/forms/frm0024.htm

There are two sample databases that do what you are interested in.

Joe Miller
joe.miller@flotech.net