Hi!
I need help for my program..
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 should i do..
i need help urgent..
thanks..