kengooch
Member
- Local time
- Today, 06:28
- Joined
- Feb 29, 2012
- Messages
- 137
I have a form with a check box named [tConcur] If the user clicks the checkbox on, I want the label of the check box to change to Green.
this is what I tried, but it doesn't work.
this is what I tried, but it doesn't work.
Code:
Private Sub tConcur_BeforeUpdate(Cancel As Integer)
If (tConcur = -1) Then
Me!LConc.BackColor = vbGreen
Else
LConc.BackColor = RGB(239, 211, 210)
End If
End Sub
Last edited by a moderator: