[AccessD] Update or CancelUpdate Without Addnew or Edit

 > And how exactly do you manipulate the background colour, font ,foreground
 > colour, etc of a tab control?

Fluff.  IF I wanted to do that I would place a label over the tab I suppose.  I have to say in all 
my years I have never had a client care.

Besides which you have shifted your argument from JIT subform to fluff.  I caught you you sly dog.

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> 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
>