Dan Waters
dwaters at usinternet.com
Thu Sep 6 11:56:12 CDT 2007
I do use a flag to allow it to run or not run. Gotta manage it! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, September 06, 2007 10:09 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SubForm and form The current event is a bad place for that kind of code unless you use flags to keep it from running repeatedly. You'd be better off putting the code in a separate routine and calling it when appropriate based on module level flags. 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 6:00 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SubForm and form Hi Charlotte, My current events tend to be quite long because they manage the screen display in many ways. No point in running it twice before the user can even see the screen! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, September 05, 2007 6:22 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SubForm and form 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 -- 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