Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Yes/No control

Status
Not open for further replies.

jehm

Technical User
Jan 16, 2006
2
BG
I want to perform a function called cancelorderonexit provided that customerid is Null ,the Yes/No control ChkStorehouse is set to True or the Yes/No field ChkWarehouse is set to True . Unfortunately the function below does not obey me, and the code is performed even though the ChkStorehouse is set to Yes
If Not IsNull(Me![customerid]) Or IsNull(Me![ChkStorehouse]) Then
CancelOrderOnExit
DoCmd.CancelEvent
End If

What is wrong ?

 
Try This...

Code:
IF IsNull(Me![customerid]) = True Then  
   IF Me![ChkStorehouse] = True OR Me!ChkWarehouse = True Then
      CancelOrderOnExit
      DoCmd.CancelEvent
   End if
End If

Hope this helps you...
Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top