Unloading of Forms in memory

[Lorna]

I'm writing an application in Access 2000 and am in the testing phase. Now what happens while testing - if I do not exit the application properly, many of the forms still stay in memory.
How can I unload them unconditionally - just for this test phase?

thanks

[Cimperiali]

I do not have access 2000 so this may not work, but you can have a try:

Find a point in your program where you're sure you will pass before quitting.
Insert this code:
dim frmF as form
for each frmF in Forms
if frmF.name<>me.name
unload frmF
set frmF =nothing
next
Unload me





Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater