Hi there,
I have intermixed my solutions below...
>Hi,
>
>My application had a few modaless form which call each other.
>Some of the form had call to open some recordset.
>I am sure of unload the form, in the unload event of
>the form, I had close all the recordset and set all
>recordset and connection to nothing.
Hmm...are you sure you got all of the RSs and connections...if one is left unterminated it can cause the behaviour you are describing.
>
>
>As for the form, I had unload it and set it to nothing too as show below
>
>calling form
>============
>
>
> with frmMain
> .Move xx,yyy
> .Show vbModal
> end with
>
>
> set frmMain = nothing
>
>
>form frmMain
>============
>
> with frmNext
> .Move xx,yy
> .Show vbModal
> end with
>
> set frmNext = nothing
>
>
>Then on exit of my application, I still had my application in memory.
>Please kindly advise me on this issue. Thank you
I've always unloaded forms. Thus, instead of setting the form to nothing, as in "set frmNext = nothing", try "Unload frmNext" when you want to get rid of it.
HTH,