How to check if a recordset is opened ?

[icongroup2003]

I have declare a recordset

public rs as new ADODB.recordset

It is used in many functions that I have in my form.

However sometimes, I encounter problem when I try to open it again as it says it is already opened. Reason because I allow the user to break the loop and exit function hence, sometimes the recordset is not closed.

Question : How can I check if a particular recordset is already opened ?
If I can check if it is opened then I can do a rs.close which will solve my problem.

Anyone with solution please help !!!