Make my tab control go away, please!

[kelsita_05]

I'm upgrading a form that was designed a while ago (not by me). It has various text boxes/combo boxes/etc. and one tab control that has 3 pages (TabCtl87). It works fine, I want to leave it there. My goal is to create another tab control on this form with two pages. One will include combo boxes and (hopefully) TabCtl87, which are already on the form. The other will have a new subform.
My problem is this: I set up the new tab control and cut and paste the combo boxes and TabCtl87 on the first page. When I click on the second page, which is where I want to put my subform, TabCtl87 still shows up!

I tried:

Me.TabCtl87.Visible = False

in the On Click event of the tab on my second page.

But it won't go away!

I also tried embedding my subform over top of the dreaded TabCtl87, but the tabs show through and make a mess of everything.

This is the first time I've delved into the world of Tab Controls and it's ruining my day (several days, actually).

Thank you!

 

[RexesOperator]

I ran into this as well. Part of the problem may be the "Name autocorrect". Here is one solution that helped me, and a link to the Name autocorrect issue.

http://allenbrowne.com/bug-03.html


Rickster57
Registered User Join Date: Nov 2005
Posts: 228


Bad access

--------------------------------------------------------------------------------

I have seen this before with tabbed forms. Every now and again Access loses it's mind with tabbed forms.
Solution: I created a new blank database. I exported your tables and query to this new database. I created a 2 tab form and then copied and pasted your existing fields from your "Corrupt" tabbed form into it.



I also found that for my tabs to work I had to have a subform for each tab. It's a nuisance but it does work. Simply copying and pasting didn't - at least for me

 

[RuralGuy]

AFAIK the *only* way to have a Tab Control ON a Tab Control is to have one of them in a SubForm.

 

[kelsita_05]

You guys rock!
Problem solved

 

[kelsita_05]

More drama with the subforms

Hi again-
So, I got my tab controls all straightened out. (thanks again!) The first one shows up perfectly. I embedded my second subform on the second page, and have been diligently modifying it for about a day. (background: I borrowed this subform from another database I have and I'm trying to adapt everything so it works).
In design mode, it looks beautiful. I've gone through and fixed any field name issues that might be throwing it for a loop. It's not giving me any errors. But when I switch to form view my subform does not show up. Details:
The first tab is selected when the form loads; it looks great. I click on the second tab and all I get is the yellow background from my subform. All my controls/fields/buttons just don't appear! And no error messages.
I've compared all the Properties settings to the database where my subform used to live. Everything is identical.
I'm throwing in the towel for today- any and all help will be much appreciated tomorrow morning when I recommence the fight!

 

[RuralGuy]

Put at least one record in the Query to which the SubForm is bound. Either that or put the form in Data Entry mode as a test.

 

[iddqd]

Actually, I've been wondering how to get rid of these pesky things myself. They don't bother me THAT much, but they just take up space in my Datasheed View forms. Setting 'Visible' to False doesn't seem to do anything as far as the UI is concerned, I'll have tab control footers whether I want them or not!

Edit: Apparently, this can be turned off in Form properties. It's called navigator buttons or something.