>>Napoleon;
>>
>>As was stated, if you are using ADO you can use the Find method. To me Find is slow but simple and I prefer to create a new SQL statement to obtain the data I require. This may result in quicker response time if you are using large data sets.
>>
>>Tom
>
>The find method of ADO is optimizable by creating an index on the field you are searching.

FYI, the Find method doesn't use any index. The Seek method does.