If statement with multiple or not criteria

[ittechguy]

I'm having a hard time getting this code to work here.

inStorage = False
inStorage = inStorage Or Me.cboEquipmentStatus.Value = 2
If inStorage _
Or Not IsNull(Me.cboEquipmentModelNum.Value) Or Not (Me.cboEquipmentModelNum.Value) = "" _
Or Not IsNull(Me.txtSerialNum.Value) Or Not (Me.txtSerialNum.Value) = "" Then
'Do stuff here
End If

Basically I have If (positive) in storage Or Not (negative) ModelNum Or Not (negative) SerialNum. In the past, I've re-wrote my code to not use "or not" and to just use "or". But it doesn't seem like I can do that for what I need it to do.

For now I have a msgBox which displays after then. I need the msgBox to display if all three criteria is met. That is,

Equipment Status is 2


cboEquipmentModelNum is not null
txtSerialNum is not null.


The problem is, I'm getting the msgBox whether value are null or not. What am I doing wrong?

[June7]

Maybe:

If inStorage AND Me.cboEquipmentModelNum & "" <> "" AND Me.txtSerialNum & "" <> "" Then

[ittechguy]

Thanks for the reply June.

I'll give that a try in the morning.

One question tho, a friend of mine who's really good at programming (most every other language bug vba, lol) had told me I need to validate for null and also for empty. So, I've been writing all my code like this because as you know, null and empty is not the same thing.

But more I work with access, I'm wondering... does it really matter?

[June7]

My suggestion will handle validation for null and empty. Because concatenation with Null returns the value of the literal text - in this case conctenating empty string.