01-17-2003, 04:02 AM
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.
01-17-2003, 07:08 AM
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'"