William Benson (VBACreations.Com)
vbacreations at gmail.com
Tue May 24 20:23:23 CDT 2011
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