searching ado data control

Buzz_1977
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.

Tryster
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'"

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum