Combine (2) If Statements

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

The code below works fine, but I need to include AND if IsNull CustPONo

If Me.Parent.[Check399] = True Then
MsgBox "A Purchase Order is Required for this Customer"
End If
 
Hi, Dave.

If (Me.Parent.[Check399] = True AND IsNull([CustPONo])) Then
...

The surrounding parentheses aren't actually needed by the compiler, but I
include them to remind me that the enclosed expression is a single boolean
value.

Hope that helps.
Sprinks
 
Back
Top