On Load Help

[NikoTheBowHunter]

I just created a checkbox on my form, that when clicked changes the background color of a text box. The problem I am running into is when I change the record, the form doesn't look to see if the box is checked or not to change the color of the text box. So if viewing record #1, click the check box, changes text box to red. click to view record #2 that doesn't have the check box checked, text is still red. If I was to load Record #2 first, when going into Record #1 it would still be gray.

So what would I need to change/address to resolve this issue? Would it be something to the effects of an On Load for something or would there be an easier route to go? Thus the reason I turn to you good peeps.

Here is the code I use for the changing the text box.



text box = [Notes History]
check box = DEFECTIVE

Private Sub DEFECTIVE_Click()
If Me.DEFECTIVE = True Then
[Notes History].BackColor = 255
Else
[Notes History].BackColor = 12566463
End If
End Sub

[Bob Fitz]

Try your code in the forms On Current event

[NikoTheBowHunter]

Thank you so much Bob!!! Solved my issue!!!!

[NikoTheBowHunter]

Disregard, figured it out.