If and Statement not working? See Syntax Below!

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

Dave Elliott

What is wrong with this code?

If [Check392] = True And IsNull(Check392) Then
MsgBox "A Purchase Order is Required for this Customer"
End If
 
What's the difference between [Check392] and Check392? Is one supposed to be
the name of a control and the other the name of a field in the underlying
recordset? If so, rename the control on the form.

It's impossible for something to have a value (i.e. = True ) and be Null at
the same time.
 
My Bad, Forgot about second criteria, was suppose to be IsNull [CustPONo]
instead!
Had a Kodak Moment.
It is working ok now.
Thanks,
 
Back
Top