Using AND with OR in IF statement

[bfont]

Hello,

Can someone tell me what is wrong with the code below? The section before "And" is not being evaluated.

Private Sub Form_BeforeUpdate(Cancel As Integer)


Dim strMsg As String
If cboActivityID.Value = "P" And EndTime.Value = "0" Or IsNull(Me.EndTime.Value) = True Then
Cancel = True
strMsg = strMsg & "End Time required." & vbCrLf

End If


Thank you for your help

[June7]

Use parens to manage the order of operations. Which logic do you want? Possibly:

If Me.cboActivityID = "P" And (Me.EndTime = "0" Or IsNull(Me.EndTime)) Then

or

If (Me.cboActivityID = "P" And Me.EndTime = "0") Or IsNull(Me.EndTime) Then

Value is default property of data controls. Don't need to type.

[bfont]

Thank you!