if rs is nothing then
'rs is closed ....
>Hi,
>
>Is any command through which I can check whether particulaer recordset is open or not. if not then I can use rs.open otherwise use existing recordset....Please.
>
>TIA
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com