How to fix the error "operation is not allowed when the object is open"?

[Sathia1]

Hello everyone,

I am using a module in access to write a query. I first opened a connection to my database, and wrote my query in SQL in the module itself, then I have the following codes:

rs_Recordset.Open Source:=sql, _
ActiveConnection:=o_Conn, _
CursorType:=adOpenDynamic, _
LockType:=adLockReadOnly

And I'm not sure why I am getting the error message above. I am thinking that may be I need to make sure something (or the 'object' as Access is refering to it) is closed but I don't know how to do that.

I would greatly appreciate suggestions. Thanks!

[romiverma]

hi,
try
if rs_Recordset.state=1 then rs_Recordset.close
before ur query