>Thank you very much .. Eric ... so I can not add DoEvents when OpenRecordset run .. is there another way for interrupting the OpenRecordset ? ..
>
>
>Regards
>Winan
Not with DAO.
If you were using RDO, you could use asynchronous method!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com