You don't call it. It is an event! When the recordset is declared, it has the special keyword "WITHEVENTS".
>But where should I put the SQL Statement, and where the rs_statusprogress should be called?
>
>Thanks
>Aston
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
