How to close a file?? (1 Viewer)

[rickyfong]

I have the following VBA to open a MSQUARE file....

Set TRANS3 = db.OpenRecordset("select * " & " from MSQUARE", dbOpenDynaset)

Then, I would like to close it but I tried the following coding and not working as a result!! Any idea?? Thanks!!

CLOSE
DoCMD.CLOSE
TRANS3.CLOSE

 

[Galaxiom]

TRANS3.Close should close the recordset.

You need to provide a better description than "not working".

 

[rickyfong]

May be I put it on the top of an afterupdate Sub, let me try to put it in another place. Is that Open recordset only worked within a Sub but not for all Sub Environment??

 

[Galaxiom]

If you need the recordset outside of the sub where it is created then you certainly don't want to Close it there.

Moreover, you would need to declare the variable in the scope where you want to use it. If it is for the whole module then you need to declare it before the first sub or function in the module.