After update to change form background
Posted on 2014-01-16
After I update a field in a form, I would like it to change the color of the form. I already put code in that on the form for an "On Current" event. This code is working great. If possible I would like it to change if the field changes, not just when you click onto the form.
The code of the "On Current" of the form is this:
Private Sub Form_Current()
Select Case Me!cmOffice
Case "Orange County"
Me.Detail.BackColor = vbGreen
Me.Detail.BackColor = vbBlue
Me.Detail.BackColor = vbWhite
WHat would the code be for the "After Update"?