Help with If OR...AND Statement

[RunTime91]

Really wish I could figure this stuff out on my own - but I can't help to think Access is a contributor to my frustration - but I digress

Simple If Or...And statement that wont work - no matter what.

Setup: Userform with 2 Combo's (cboAssoc & cboTeam) - Entering a value in one will set the other to an empty string ("")

If neither Combo has a value then the entire population of data is pulled for whatever date range is selected.

The following two lines work perfectly:

If IsNull (Me!cboAssoc) Or Me!cboAssoc = "" Then
   Do Something
End If

If Me!cboAssoc <> "" Then
   Do Something
End If

Neither of the following will work at all: The first one is the one I would really like to use as it is (supposed to) check if either ComboBox (cboAssoc & cboTeam) is devoid of any value

If IsNull (Me!cboAssoc) Or Me!cboAssoc = "" AND IsNull (Me!cboTeam) Or Me!cboTeam Then
   Do Something
End if

I gave up on the above and tried using singular If statements such as below - nope, wont work

If Not IsNull (Me!cboAssoc) Or Me!cboAssoc <> "" Then
   Do Something
End if

WTH am I doing wrong? Ugh!!



Thanks

[davegri]

Try it this way:

If (IsNull (Me.cboAssoc) Or Me.cboAssoc = "") AND (IsNull (Me.cboTeam) Or Me.cboTeam = "") Then
   Do Something
End if

Notice dot replacing bang. The red was missing in your code.
The parens help Access understand how to interpret the AND mixed with the ORs

Another approach:

If Len(me.cboAssoc & "") = 0 AND Len(me.cboTeam & "") = 0 Then
    Do something
End If

[CJ_London]

another way is

If nz(Me.cboAssoc,"") = "" AND nz(Me.cboTeam,"") = "" Then
    'do something

[ssanfu]

More info

In math, there is something called Precedence of Arithmetic Operators
It codifies the order to do the calculations:
Parentheses,
Exponents,
Multiplication/Division,
Addition/Subtraction

In coding, there is also something called the Precedence of Logical Operators
It codifies the order to do the Logical order in programming:
Not,
And,
Or



So, when you write this:

If IsNull (Me!cboAssoc) Or Me!cboAssoc = "" AND IsNull (Me!cboTeam) Or Me!cboTeam Then
      Do Something
End if

VBA interprets it as

If IsNull (Me!cboAssoc) Or (Me!cboAssoc = "" AND IsNull (Me!cboTeam)) Or Me!cboTeam Then
      Do Something
End if

First it analyzes (Me!cboAssoc = "" AND IsNull (Me!cboTeam)), then that result is ORed with IsNull (Me!cboAssoc), then that result is ORed with Me!cboTeam

So yo need to use Parentheses to control the logic order of the comparisons.

If (IsNull (Me!cboAssoc) Or Me!cboAssoc = "") AND (IsNull (Me!cboTeam) Or Me!cboTeam) Then   '<<-- this must evaluate to True for the next statement to execute
      Do Something
End if

Clear as mud??