[RESOLVED] Access - Changing control property on one record but not all records

[RiceRocket]

Hello, I have a lot of experience with VBA in Excel, but next to no experience with an other Office Apps. I have been creating an Access project and I am still trying to figure everything out.

My problem is this: I am viewing records from a table in a continuous form view so that I don't have use the Record Navi controls to cycle through my records (I can just scroll down). I have a control on the form that is called [Status]. I want to be able to change the [Status].BackColor property of the [Status] Control, but i want it to change based on the value of the control FOR EACH INDIVIDUAL record.

I know this sounds confusing, so i'm going to try to reiterate what i just wrote. I have a control on a form that is bound to a table and displays the value of [Status] in the table. The control is a combobox that can be changed on the form. Depending on the value of the combobox, i want the backcolor to change, but i only want it to change for that record. What happens now is that if i change the value of the combobox, the BackColor will change on ALL of the records. Is there any way to change it on just the record for which the value changed?

Thanks in advance for all your help!!!