>Hi,
>
>Is there any function to check whether the recordset exist. Cause I'd like to close those unclosed recordset before release form
>
>Thanks
>Aston

You could check if the object exists with Is Nothing and then check the State property to see if it's open and needs closing. Something like: (syntax not tested)

If Not myRS Is Nothing Then
  If myRS.State = adStateOpen Then
    myRS.Close
  End If
End If
'.. etc.