Closing all the Form Active before new form is Open

[Asher David]

Hi,

I needed a help how can I close all the opened/active form before I will run inside the VBA code to open the new form I want... Is this possible to do?


Thanks!

[bobp0303]

This is probably the ugliest way to do it, but if you keep track of forms as you open them (in a collection, say) then you just walk down the list, closing each form in the collection. -- don't forget to delete the form from the collection after closing the form.
Bob.