searching ado data control

I have an ADODC control on a form that retrieves values based on a SQL select statement. This works fine however its retrieveing over 1000 records. is there a way of being able to search through the recordset for specific values.

You could use either the Find method or Filter method of the Recordset eg

'This will filter the records displayed
ADODC1.Recordset.Filter = "ColumnName = Value"

'This set the current record to the first matching row
ADODC1.Recordset.Find "ColumnName = 'MyValue'"