Is there such thing as 'Is not' or is different to ?

Hi guys, Is there such thing as Is not?

I tried it but i got type mismatch... I thought this would work ...





If Combo3.Text Is Not "All Databases" And Combo1.Text = "All Agents" Then



Set rs = db.OpenRecordset("SELECT * FROM `Leads` WHERE `CurrentStatus` = " & "'" & Combo2.Text & "' AND `Calling From` = " & "'" & Combo3.Text & "'")




End If



Thanks!

Different from? You mean like not equal to?

Code:

---

If A <> B Then

---

___________________________________________________________________
Same as
Different from
Similar to

You could also use

Code:

---

If Not A=B Then

---

You can try the following way also . it is really much better.

Code:

---


If  not (Combo3.text ="All Databases") then 
  if (combo1.text="All agents") then
    Set rs = db.OpenRecordset("SELECT * FROM `Leads` WHERE `CurrentStatus` = " & "'" & Combo2.Text & "' AND `Calling From` = " & "'" & Combo3.Text & "'")
  End if
End if

---

Code:

---

If Not Combo3.Text = "All Databases" And Combo1.Text = "All Agents" Then
  Set rs = db.OpenRecordset("SELECT * FROM `Leads` WHERE `CurrentStatus` = " & "'" & Combo2.Text & "' AND `Calling From` = " & "'" & Combo3.Text & "'")
End If

---