Here is some updated code, you might need to tweak it depending how your entire Save procedure is structured:
Code:
'2: If statement with Else updated
If Me.chkBox = -1 Then
If InStr(nz(Me.txtBox,""), "blue") = 0 And InStr(Nz(Me.txtBox,""), "brown") = 0 Then 'covers Scenarios A,B,C,D
MsgBox "Make sure to include box color in notes (Blue or Brown).", vbExclamation, "Blue/Brown Box"
Me.txtBox.SetFocus
Exit Sub
End If
Else
'checkbox not checked
If Not isnull(Me.txtBox) Then
'scenario F
msgbox "You entered a note but you did not checked the box!",vbExclamation,"Blue/Brown Box"
Else
'scenario E - do nothing to allow to exit if and Save
End If
End If
Cheers,