hi.please help me how to program a command search in simple way.because all sight here so hard and i'm just a beginner in vb6.with adodc codes,thanks :)))

I hope u know how to connect adodc1 to your database.

'Put this on a command button

Adodc1.RecordSource = "SELECT * FROM TABLE1 where last_name =  '" & Text1.Text & "' "
Adodc1.Recordset.Requery
Adodc1.Refresh
Adodc1.Caption = Adodc1.Recordset.RecordCount

In this example all the last_name field that equal to text1 will count