>>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com