Stuart McLachlan
stuart at lexacorp.com.pg
Tue May 24 20:47:14 CDT 2011
I gave up on shared subforms a long time ago - had too many situations where new requirements meant that the same sub-form no longer worked on both master forms. Like you , I try to keep event procedures down to simple function calls with all the grunt work done in standard modules. -- Stuart On 24 May 2011 at 21:23, William Benson (VBACreations. wrote: > Works fine if ... you don't share subforms between multiple forms. I > suppose you could always just duplicate the subforms, but I find > keeping the code synchronized between multiple copies a mild hazard. > > Of course lately I have been calling procedures and functions stored > in standard modules, when events on my forms and subforms run ... so > it hasn't been as big a deal. > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart > McLachlan Sent: Tuesday, May 24, 2011 6:09 PM To: Access Developers > discussion and problem solving Subject: Re: [AccessD] How do I create > list of all forms/subforms > > That's why I use a naming convention in complex applications that > specifically identifies subforms and keeps them together in the forms > list :-) > > frmMain > frmMain_subCustomersList > frmMain_subCustomerDetails > > > > > I want to generate a list of all the forms and their subforms in my > > application (whether loaded or not). Right now I'm looping over > > Application.CurrentProject.Allforms and getting the name of every > > form, but the object doesn't distinguish a subform from a form. I > > tried the Type property but they're all Type 2. Is there a routine > > out there I can scarf? Thanx, Darrell > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >