I have a check box and a Command Button. I am trying to set it so that when the check is checked the Command button is enabled. That works, except when I got to the next record it still has the command button enable regardless if it is the checked or uncheck on the next record.

Details

Private Sub MadeNotesChk_Click()
On Error GoTo Err_MadeNotesChk_Click

    If MadeNotesChk.Value = True Then
        OpenBtn.Enabled = True
            Me.OpenBtn.BackColor = RGB(100, 28, 30)
        Else
            OpenBtn.Enabled = False
        Me.OpenBtn.BackColor = RGB(50, 100, 150)
    End If
Exit_MadeNotesChk_Click:
    Exit Sub
Err_MadeNotesChk_Click:
    MsgBox Err.Description
    Resume Exit_MadeNotesChk_Click
    
End Sub

Added this to BeforeUpdate to see if that would help when going to the next record - it didn't

Details

Private Sub MadeNotesChk_BeforeUpdate(Cancel As Integer)
    If MadeNotesChk = False Then
        Me.OpenBtn.Enabled = False
        Me.OpenBtn.BackColor = RGB(50, 100, 150)
    Else
        Me.OpenBtn.BackColor = RGB(100, 28, 30)
    End If
    
End Sub

I need this to apply only to the current record