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 SkipVought 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
Feb 12, 2004
3
0
0
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