>Hi .. Eric thanks for your help, it works, but can you explain to me why should I add the DAO or ADO prefix?.. because I always do the samething (without any prefix) and no problem ..? thanks for your explaination ..
Because both object have a Recordset object. If you only reference one of them there is no problem but as soon as you reference both, you have to specify the one you want for a particular variable.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com