Sorry but you have it wrong again, try to use the code tags when posting code to preserve the indenting (which helps you visualize the errors in the If blocks):
Code:
'If Me.chkBox = -1 Then
'If InStr(Me.txtBox, "blue") = 0 And InStr(Me.txtBox, "brown") = 0 Then
'MsgBox "Make sure to include box color in notes (Blue or Brown).", vbExclamation, "Blue/Brown Box"
'End 'Miising IF
'End If 'you do not use this if you want an ELSE
'Else
'Do something
'End If
'two versions:
'1: no Else just let the program flow after the If statement
If Me.chkBox = -1 Then
If InStr(Me.txtBox, "blue") = 0 And InStr(Me.txtBox, "brown") = 0 Then
MsgBox "Make sure to include box color in notes (Blue or Brown).", vbExclamation, "Blue/Brown Box"
End If
End If
Do something
End If
'2: If statement with Else
If Me.chkBox = -1 Then
If InStr(Me.txtBox, "blue") = 0 And InStr(Me.txtBox, "brown") = 0 Then
MsgBox "Make sure to include box color in notes (Blue or Brown).", vbExclamation, "Blue/Brown Box"
End If
Else
'Do something
End If
'Do some more
Cheers,