Recordset question

[Guest_imported]

How can I know if a recordset is currently opened so I can do I close?
I'm working with ADO.

I'm doing:

rstest.Open "SELECT....", conn, ...

And everytime I do this, I must check if the recordset is opened or not. How can I do it?

 

[woyler]

If Not rstest.State = adStateOpen Then
rstest.Open "SELECT....", conn, ...
else
'the rs is open
end if