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:
Code:
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
Code:
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