Max Wanadoo
max.wanadoo at gmail.com
Tue Sep 22 13:35:03 CDT 2009
Only one sub form is loaded at any one time. Max -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 22 September 2009 17:41 To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] JIT Subforms, was Merge rows (now: seriously OT) Do you have a single subform control? If so then you can't have 10 subform controls and all of them left bound. John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: >> With your approach leaving the subforms bound is difficult to say the > least. > > As difficult as one line of code <g> > > Max > > > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: 22 September 2009 17:14 > To: Discussion concerning Visual Basic and related programming issues. > Subject: [dba-VB] JIT Subforms, was Merge rows (now: seriously OT) > > Max, > > It doesn't have to be either / or. > > I used to do the unbind when the user clicked off the tab and William > objected, saying that his > users prefer that it stay bound. All it takes is removing the form name > form the form control and > voila, it is unloaded. Leave it there and voila, it stays bound. > > My personal feeling is that unbinding it makes a lot of sense when there are > a ton of tabs, and / or > the subforms contain a ton of records. The time to navigate through the > parent record is a lot less > (faster) > > OTOH if there aren't many subforms then it often makes sense to leave it > bound. > > One way or the other, I do exactly this, decide on a form by form basis > whether it makes sense to > unbind as the user leaves the tab. > > With your approach leaving the subforms bound is difficult to say the least. > > John W. Colby > www.ColbyConsulting.com > > > Max Wanadoo wrote: >>> Does that clarify it for you? >> >> It does, so really with the Tabs JIT you are not much better off. >> >> With my On-Demand approach, only data that is wanted there-and-now is > loaded >> each time you navigate between records AND furthermore, I give them the >> option of a blank sub-form which means there is no extraneous data > overhead >> when navigating unless the user wants it. >> >> I think my On-Demand approach is better for lots of reasons, but if your > are >> happy with your JIT-Tabs approach then I am happy for you. >> >> >> >> Max > > _______________________________________________ > 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