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