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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine (2) If Statements 1
Two message boxes 1
Spell Check button issue with subform 2
Field on form required depending on value in another field 3
Restrict entering Null or Empty in Textbox - Access 2007 0
Run Time Error 3075 2
If then Statement for Picture 4
If Statement for sub-form needed! 11

Back
Top