[AccessD] Loading more than one instance of a form

Stuart McLachlan stuart at lexacorp.com.pg
Sat Jun 24 17:14:33 CDT 2006


On 24 Jun 2006 at 16:23, JWColby wrote:

> If you want to load a form you normally use docmd.open.  However it is
> possible to use a set statement:
> 
> dim myform as form
> Set MyForm = new form_MyFormName
> 
> which is really setting a reference to the form's class.  Is there a syntax
> to load it from a collection so that you could use a syntax something like
> 
> set MyForm = new someobject.somecollection("MyFormName")
> 
> I have never been able to figure out how to do this but I thought I'd ask
> the experts (you guys).
> 

That syntax should work, it you can actually get a collection of Forms and 
not AccessObjects which happen to be forms.

How are you filling your collection?

-- 
Stuart





More information about the AccessD mailing list