If Not Loop Syntax

[Roey]

What is the correct syntax for testing if two combo boxes don't have text values in them

 

 

Works

--------

 

If Me.cboBox1.Text = "" And Me.cboBox2 = "" Then

Exit Sub

End If

 

..... Code

 

Fails

------

 

If Not Me.cboBox1.Text = "" And Me.cboBox2 = "" Then

.... Code

 

End If

[Cags]

I don't quite understand the question, you say the first method works, so in that case, thats the method to use.

 

The second method doesn't work because essentially I believe what it says is..

 

If CboBox1 is anything other than "" and CboBox2 is ""

[PlausiblyDamp]

If Not (Me.cboBox1.Text = "" AndAlso Me.cboBox2 = "") Then
.... Code

End If

Edited March 4, 2004 by PlausiblyDamp

[TechnoTone]

If (Me.cboBox1.Text & Me.cboBox2.Text) = "" Then
...
End If