Reopen a recordset

[Morpheus1981]

Hi,
Can someone tell me the right way?
I am using ADODB. But when I want to change the query in my Recordset. I have to close it Open it and set the Datasource of all my objects again.
Am I doing it in the right way or there's better one.

Please I am not asking for way to do it with other kind of objects I am talking with ADODB, is the rith way.

Thanks!!

 

[santhosh11]

Instead of closing and opening for recordset
"Requery" method is there to change the query for records set