Max Wanadoo
max.wanadoo at gmail.com
Mon Sep 21 17:27:34 CDT 2009
And how exactly do you manipulate the background colour, font ,foreground colour, etc of a tab control? Guess what you can do with a button or even better a label simulating a button or even better a graphic simulating a button? Forget tabs. Trust me! Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 21 September 2009 23:24 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Update or CancelUpdate Without Addnew or Edit >Voila! Max wins again! Well, not exactly. Do the exact same thing only have your subforms reside on the pages of a tab. Now as the tab click event fires, load the subform for the correct page, just as you do for your buttons. the difference is that my code is clean, handling one control (the tab control). Yours has to be customized to the number of buttons you have on your form. Add a subform, add a button, add a button event handler. In my case, add a subform, just add a tab. No code change at all. In fact this is the one lonely place where I use the tag property... of the subform control to store the subform to load in that subform control. In the subform control I simply remove the name of the form to load and in the OnClick of the tab control I yank the name from the subform control tag and place it back in the source property to cause the subform to load. Works a treat. Add a tab, drag a subform onto the tab. Cut the subform name out of the source property and place it in the tag. Instant JIT subform. Not a single button handler in sight. Voila... John wins again. ;) John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: >> Max, you aren't listening. > > True. > > I wasn't talking about loading subforms as part of the tabs, but in having > controls on the tabs screen space. IOW, one form, no subforms. Main form > has dozens of tabs each displaying different information from the mainform > source. > > Break all that out into subforms which load JIT based on buttons. Voila! Max > wins again! > > Max -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com