Charlotte Foust
cfoust at infostatsystems.com
Tue Sep 22 09:58:55 CDT 2009
It means that once you set the master/child links (in Access), for instance, the subform would stay bound, so you wouldn't have to load it again when you moved to another tab and back. In our .Net apps, we drop a subform control on a particular tab. When the tab is selected, we load the subform and call its custom FillData routine, after that, as long as the parent form is open, we don't have to reload that subform, only point it to the appropriate record. Does that clarify it for you? It's possible to use a single subform control and change which subform is bound to it, but that involves unloading and reloading the subform, so the tabl approach is faster. Charlotte Foust -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Tuesday, September 22, 2009 7:53 AM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] Merge rows (now: seriously OT) Charlotte. Quick question please. You know when we were talking about the tabs not doing anything unless instantiated, (ie, user clicked on one), does that mean that in that case the "contents" of the subform would be loaded for that tab, and the stay loaded? Thinking about that in bed last night. What am I like, eh! MAx On 22/09/2009, Charlotte Foust <cfoust at infostatsystems.com> wrote: > Hmmn ... > > If wiseGuy = 'Gustav' The Kill(wiseGuy) > > Charlotte > > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock > Sent: Tuesday, September 22, 2009 1:10 AM > To: dba-vb at databaseadvisors.com > Subject: Re: [dba-VB] Merge rows (now: seriously OT) > > So Max wins again! > > /gustav > >>>> "Stuart McLachlan" <stuart at lexacorp.com.pg> 22-09-2009 00:55 >>> > > Select Distinct, KeyField, Max(fld2), Max(fld3).......... > > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com