>Eric,
>
> >It is a bad idea to put this in the Change event. Every character pressed make the recordset to be rebuild!
>
> I've seen many examples like this in other VB forums, its like performing an
>incremental search in the database. Is there any ADO example in the UT?
I don't have that example but this is exactly what you were doing.
Like I already said, move to ADO and use the Filter method.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com