Hello All,

when I declare a dim on a form in the general area is it default private to the form public to all forms?

when I unload the form, will these dims disappear?

I'm wondering because I created some ADO.recordsets and when I close the form (click on the x) and reopen the form I get an error stating that the recordsets are still open.

I have since put statements to close the ado.recordsets in the form unload but what the hell? How can they be open if I close the form anyways? cause when I reopen the form it has to redeclare the variables doesn't it? or does form1.show only unhides it?

what there like no garbage collection?


Thanks !


Marci Sarwan ([email protected])