Hia all,

In a project, a recordset is openend. In the program flow, it happens
that the rst is closed in other procedures. If I trie to close the rst
again, I get an error maessage.
Is there a way to check if a rst is open or close rst = nothing or is ""
(I tried but it didn't work...)???

Thanks in advance,

Kurt.

If Not rst Is Nothing Then rst.Close


--

Ken Snell
<MS ACCESS MVP>

"Kurt Blom" <Kurt.Blom (AT) UGent (DOT) be> wrote