Charlotte Foust
cfoust at infostatsystems.com
Thu Apr 27 13:27:10 CDT 2006
I've done that before too, but I also put unbound subform controls on individual tabs and then load them in the tabchange event if they aren't already loaded. I don't know which is faster because I've never tried comparing the two approaches. Has anyone? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Thursday, April 27, 2006 11:08 AM To: Access Developers discussion and problem solving Subject: [AccessD] Dynamic subform loading Thought this article and method might be of interest to those having performance problems on multiple tabbed subforms with say ten tabs and 10's of thousands of records. I remember a couple of people asking about it a few months back. There aren't any subforms embedded on the tab-pages. There is one unbound subform object floating around. Through code, it is dynamically resized, moved and loaded with the correct subform, depending on which tab page is selected. www.databasejournal.com/features/msaccess/article.php/3599781 -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com