Is there a way to determine whether a recordset has been instantiated ?
For eg.If I have

Option Explicit

Dim rstDetail As ADODB.recordset
:
:
:
:
Set rstDetail = Conn.Execute("SELECT * FROM Table",,adcmdText)
:
:

If there is a runtime error when executing the above statement, the program will exit. During the exiting function, I will close every recordset that I dimmed but for the above recordset, I will have an error coz' the recordset is not created. So, is there anyway to check the status ? I tried to use 'rstDetail.state = adStateOpen' but failed because this cannot determine whether the recordset has been instantiated.