I plan on putting an Access form object in the collection. The real problem
is I can't seem to open a second copy of a form in Access. My form displays
parts (parent parts) that may or may not be made up of other piece parts. The
piece parts are shown in a sub-form--there are several sub-forms. I want to
be able to double-click on a piece part and show it as the parent part with
any of its piece parts. I can do this, but as soon as I do the form that
displays the original parent part is replaced with the new parent (elevated
piece part).

I was hoping that in the "Before Close" event that I could store the
original parent form object in a collection and then let the form continue to
close; then let Access replace the original parent form with the elevated
piece part to parent form.

Is all that clear as mud.

My choice may be to create a class and then a collection of this class with
the information needed to open the original form in it's initial state. I
would like to create a stack of the forms opened by the user, let them choose
any form to return to and continue from there. Methods for this "stack" class
would include "Pop, "Push", "Top" and "Empty" which are standard stack
methods. Of course, that may require a second class to hold a collection with
the stack methods. Rather that program all those "classes", a collection has
the methods (different names but same functionality) and would save a great
deal of effort trying to figure out how to write a "Collection" class in VBA.