Create new form instance at the module level

[DevSteve]

I'm trying to create a new instance of an existing form, set it's record source, and display the form for the user. I can create the instance and display it, but as soon as the code stops executing the form instance goes out of scope and disappears. I've read that I need to... declare the variable that represents the new instance of a form class at the module level, which I mostly understand, but how do I actually do this?



I created a module, and a public sub to create the new form instance, then I call the sub from a procedure connected to a form (where the selects options). However, again my new form instance is gone when the code stops.

[DevSteve]

I needed to add the new instance to a public collection. Then I could keep the form in scope.