searching ado data control

01-17-2003, 03: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, 06: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'"

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum