Charlotte Foust
cfoust at infostatsystems.com
Wed Sep 5 18:22:20 CDT 2007
Sorry, Dan, but it sounds like you're trying to do something may not need to be done ... Or at least not as you're doing it. WHY are you trying to manage the subform's Current event. It's called by Load, but it fires much more frequently than that. Maybe you're trying to solve the wrong problem. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Wednesday, September 05, 2007 4:07 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SubForm and form Hi Shamil, What I've used in the past is a public Modular Boolean variable set in the main form's module. It's default value is false, of course. When the subform's load and open events are running before the main form is opened, the parent's Boolean variable is false, and the code is written to exit out of the subform load and/or open events. Only when that variable is explicitly set to True will the code not exit out. It can be set to true in either the parent form or the subform. What I'm actually managing is the subform's Current event, which is called by the Load event. I was just looking for an alternative. Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Wednesday, September 05, 2007 11:35 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SubForm and form <<< I sure would like to manage a subform's load and open events. >>> Dan, That needs tricky programming if possible at all to manage these events using WithEvents because subform's Load and Open events fire *before* form's Load and Open events... IOW you'll need to use Me.Parent.SomeCallbackName callback procs from subform's module to "inform" parent form about subform's Load and Open events... -- Shamil -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com