Conditional Visibility - based on sub-forms

[twildt]

I have a main form with several subforms within it. These subforms are navigation tabs. In the footer of the main form I have a textbox that I want to hide unless the 2nd tab is selected.



Details:
3 Tabs, 1 subnavigation subform, 3 tab indexes(0,1,2)
tab index 1 the textbox on the main form(parent) should be visible. tab index 0 and 2 the textbox should be hidden.

Any idea how I can do this?

I was thinking I could do something like when tab index 1 is onFocus then textbox = visible and vice versa on the other tab indexes?

[June7]

Is this a tab control, not a navigation form?

Determine which page of tab control has focus by testing the Value property of the tab control. Value of tab control is the index of the tab page.

Me.textboxname.Visible = Me.tabcontrolname.Value = 1

That code would probably have to be in the form Current event and the tab control Change event.

[twildt]

Where is the name of the "tabcontrolname"? Is that the name of the tab itself or somewhere else? Right now the tab names are still default chosen names such as 'NavigationButton9'.

[twildt]

Here is what I tried and it didn't work, compile error:

Private Sub Form_Current()
Me.tbox_total.Visible = Me.NavigationButton9.Value = 1
End Sub

[June7]

If this is a navigation form (see question in post 2), I can't help.

[twildt]

its a tab control. Index is 1. I'm not sure where to put that code yet.

Private Sub Form_Current()
Me.tbox_total.Visible = Me.NavigationButton9.Value = 1
End Sub

[June7]

NavigationButton9 is the default name of tab control?

My default name is like TabCtl89.

If you want to provide db for analysis, follow instructions at bottom of my post.

[twildt]

Yes, my tab control that I inserted to my main form the tab's at the top are all named "NavigationButton". I have 3 tabs in that navigation frame. The tab I want the textbox(tbox_control) to be visible on is "Tab Index 1".

I may have renamed the default Tab Control names earlier and forgot sorry.

Office 2010

[June7]

Navigation frame?

Guess I need pictures.

All I can say is the code I suggested works for me.

[twildt]

Here is pic of main form in design view..

[June7]

That looks like a navigation form.

How did you create this form/subform arrangement.

[twildt]

I started with a blank form. In the Form Design ribbon I used the control "Tab Control" and dragged the control into the form to create my tabs. Then in each tab I linked their "Navigation Target Name" to pre-built forms. So each tab is opening a form but they are in tab form.

[June7]

When I drag a tab control to form I don't have 'Navigation Target Name' property. I do see that property when I create a navigation form. Therefore you have a navigation form. I can't help you. I don't like nor use navigation form.

Referencing controls on navigation form is too frustrating for me.

Best I can offer is suggest you search the forum on topic navigation form, restrict to my user name if you want. I have responded to several in attempts to help with navigation form. Here is one
https://www.accessforums.net/forms/t...orm-32053.html

[twildt]

Your right, I somehow have navigation control with tabs. Anyone else got any advice for me?

[June7]

Don't use navigation form. Don't use wizards (I never do).

Create a normal form. Click Form Design from the Create ribbon. In design view add tab control.