DAO Status

[Andrew]

What is the property that I can use to return whether a DAO Recordset is opened or closed?

Thanks,

Andrew

If you close recordset, set it to Nothing explicitly, using this sintax:
Set RS = Nothing.
Then if you need to know if that recordset exists, you can check it with IsObject function. Something like this:

If IsObject(RS) then MsgBox "It's alive"




HTH
Vlad