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

[JamieWarren09]

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!

[dilettante]

Different from? You mean like not equal to?

If A <> B Then

___________________________________________________________________
Same as
Different from
Similar to

[DataMiser]

You could also use

If Not A=B Then

[firoz.raj]

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

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

[jmsrickland]

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