determine recordset closed?

[kovan]

how does one determine if a recordset is opened or closed?
i tried

if rs.open then
msgbox "Record is open
else
msgbox "Record is closed"
end if


it didn't work, and i didn't expect it to work
but i thought i would give it a shot before posting a message on it
thanks

[kovan]

just answered my own question
if anyone wants to knw how

you check for if RS.State = adStateOpen

[Gary.Lowe]

Here is another way Kovan



'Good for closing recordset's, connection, workspaces
If Not rs Is Nothing Then
rs.Close
Set rs = Nothing
End If

'Something similar to yours.

If Not rs Is Nothing Then
msgbox = "Recordset is open"
else
msgbox ="Recordset is closed"
End If


I had some problems that if the recordset was closed the adStateOpen returned an error. Not sure if it was my programming though.