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!