USe CreateObject to create a new form

[BluePlastic]

Hiya



I have a function that accepts a string variable that is the name of a form (e.g. "frmMain") and I need to create a new instance of the form, which I can't use the New word to do as it doesn't accept a string variable - so I was expecting to use CreateObject:

Sub subA (pstrFrmName as string)
Set gfrmAny = CreateObject("MyDB.form_" & pstrFrmName)
End Sub

But I receive error 'ActiveX component can't create object'

Any ideas please?!

[June7]

Google: Access vba multiple instances of form

Here is one
http://bytes.com/topic/access/answer...form-ms-access

[BluePlastic]

No that just indicates how to open multile firms, not 'accepts a string variable that is the name of a form'.

[June7]

I believe the code uses a loop to open 4 instances of the same form. I thought it could be adapted to open only the one duplicate instance you want. But I understand now what you mean by New does not accept variable. However, all examples I can find show use of New. Even Allen Browne used it http://allenbrowne.com/ser-35.html

[BluePlastic]

Indeed. I think the answer is that is is not possible.

[June7]

Maybe. But you know the names of all forms that could possibly want to do this with, right? Build a case structure in procedure and use the variable input to pick the correct case which has the form name hard coded with the New. It means repeating the New line in each case but only have to do it once for each form and then it's done.

[BluePlastic]

The case structure is what I currently have (120 forms so far) and am trying to replace :-)

[June7]

Why would you need to have multiple instances of virtually every form in project? Oh well, it is built and works? Sounds like you will have to stick with it.

[BluePlastic]

It's been running for 15 years.

I make no assumptions for power users about what they should and shouldn't be able to open multiple copies of - I give them full flexibility with not much overhead as it's all from a central function: I've done it for a few so I might as well implement it for the lot.

This is investigative prep for a rewrite (and me trying to get a better grip on classes) - the 2GB file size limit is becoming a pain for 8 GB of data a month :-)

Nearly every form can be opened in the context of a particular area of the business and the code deals with this filtering of the data to allow that via passing of variables.