Ken Ismert
KIsmert at TexasSystems.com
Tue Jan 20 10:32:46 CST 2004
Hello Group:
As you know, you can instantiate an Access form, just like any other object,
by using its class name:
Dim rFrm as Access.Form
Set rFrm = New Form_YourForm ' form 'YourForm'
This syntax allows you to create multiple open instances of a form, a
necessity for my framework. However, I've run into a problem.
What I need is a simple, one-line way to instantiate a form object using a
string:
sFormName = "YourForm"
Set rFrm = MFOS("Form_" & sFormName) ' MFOS = "Magic Function or
Syntax"
Note: Because of the multiple instance requirement, DoCmd.OpenForm won't
work. It can only make one instance of a form.
I can't find a CreateObject syntax that works. In my current function, I use
a big Case statement matching the form name to it's class. This has become a
pain, because every time I add or remove forms, I have to edit the function.
Have any of you found a way to do that?
-Ken