adodc search help

[Markee]

Hi!
I add a search the Adodc in my program with a combo box category,
but when i run the program and search...
the category "ID" not searching..

this is my codes

Private Sub Command1_Click()
If Text1.Text = "" Then
MsgBox "Type To Search"
    Else
    If Combo1.Text = "ID" Then
    Form2.Adodc1.Recordset.Filter = "ID='" & Text1.Text & "'"
    Else
    If Combo1.Text = "Surname" Then
    Form2.Adodc1.Recordset.Filter = "Surname='" & Text1.Text & "'"
    Else
    If Combo1.Text = "First Name" Then
    Form2.Adodc1.Recordset.Filter = "FirstName='" & Text1.Text & "'"
    Else
    If Combo1.Text = "Middle Name" Then
    Form2.Adodc1.Recordset.Filter = "MiddleName='" & Text1.Text & "'"
    End If
    End If
    End If
End If
End If

what can i do..
i need help urgent..

thanks..

[Lenggries]

What datatype is the ID column?

[DataMiser]

Sounds like the ID column is numeric in which case you need to loose the 's

Form2.Adodc1.Recordset.Filter = "ID=" & Text1.Text