How to check whether a recordset is closed?

[sohjai]

What I want to know is, how can I check whether a recordset is closed or not??

This is my first time to write VB code, I guess this might be a very simple question, but I really have no idea how to do it at the moment.........

 

[Yazster]

check the STATE of your recordset.

if recordset.STATE=0 then your recordset is closed.

 

[Terpsfan]

Dim objRec as ADODB.Recordset
Set objRec = New ADODB.Recordset

objRec.Open "Select * From Accounts",objConn,adOpenDynamic, adLockOptimistic,adCmdText

If objRec.State = adStateClosed Then
MsgBox "Recordset could not be opened"
End If

 

[Guest_imported]

Thank you for your help, one more question please

Then how can I check whether the recordset is set to Nothing?