color row in subform if a value filled in

Hi all,



I created a subform in side a form where I have some data. The idea is to fill in the row with a color if a value is met, like "Reset".

Conditional format is working (for one field), but in Access 2003 I can only have 3, and I have like 6 values to choose from. I tried to find some answers, but can't find nothing :-(



I use the below code to no avail:

Code:

---

Option Compare Database



Private Sub Form_AfterUpdate()

If Me.Legend = "Reset" Then

Me.Legend.BackColor = vbRed

End If

End Sub

---

Any idea how this could be done?



I'm adding the test database so you could check it out.



Greetings.

Attached Files

ColorRows.mdb (320.0 KB)

color row in subform if a value filled in