Before update, after update...????

[jeo]

I can never get this right and it's frustrating.
I have a field on the form called OverallProjectStatus - it's a combo box and it has values: green, yellow, red.
If a user selects green as a value I would like BackColor of the form to turn green color.
I tried both before update and after update events on this combo box as well as on the form's before and after update events and it's not working.
Could someone please help me put this code in the right place.
If Me.OverallProjectStatus = "Green" Then
BackColor = 13434828
End If
Thanks!

 

[Taff]

Hiya Jeo,

Try putting your code in the after update event of your combo box but change the line 'BackColor = 13434828' to Detail.BackColor = 13434828

Hope this helps.

Taff

 

[jeo]

Yes, that did the trick.
Thanks so much!