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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If Clause

Status
Not open for further replies.

keks

Programmer
Joined
Feb 12, 2004
Messages
3
Location
BG
I need a help with an If Clause. i have three contradicting conditions and the results are not always stisfactory.
The conditions are :

If IsNull(Me![Customerid]) = True Then
If Me![ChkStorehouse] = False Or Me!ChkWarehouse = False Then
dosomething

I wil explain what i want to do:
1. The entire code must work only when Customerid is not null
2. the code DoSomething must not work if
ChkSotreshouse = True
or ChkWarehouse = True






 
If I have read you correctly, this should be the correct If Clause...

Code:
If Not IsNull(Me![Customerid]) = True Then
   If Me![ChkStorehouse] = False AND Me!ChkWarehouse =  False Then
      dosomething
   End If
End If


Regards,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top