Testing for when a Tab Control Page is selected

[Bhujanga]

I have a form with a tab control on it that has about 5 tabs.When one of the tabs is selected, I want to set the "Visible" property from "No" to "Yes" on a subform that resides on the main form, but outside of the tab control area. Then I want it to disappear again when any of the other tabs are selected.

In design view each tab (or "Page") has a click event associated with it. I thought that by attaching the code to this click event, I would be able to acheive the desired result, but alas; click as I will on the page, it doesn't seem to acknowledge my code (Note: I've tried putting a trivial message box code in there just see if it's getting into the code and nothing.)

Also, is there a property for a TabControl that return which page is active in general? So you could say something like "If Forms! [TabCtrl5].Page = 4 Then ...."

Thanks.

[Rabbit]

Use the Tab Control's Change property. Calling the tab control returns the page number it is on.

[Bhujanga]

I'm not sure what you mean by "calling the tab control" to return the page number. I put the code in the Change Event of the tab control, as you suggested, but I'm still not finding the right syntax to get the page number. Just using the name of the tab control comes up null, and if I use "Me![TabControlName]" I get and error, as well as "Me![TabControlName].Page".

Thanks for your help.

[Rabbit]

I'm not sure what you mean by "calling the tab control" to return the page number. I put the code in the Change Event of the tab control, as you suggested, but I'm still not finding the right syntax to get the page number. Just using the name of the tab control comes up null, and if I use "Me![TabControlName]" I get and error, as well as "Me![TabControlName].Page".

Thanks for your help.

Are you using Access 2003? In 2003 I use Me.TabControlName and it returns the page number.

What is the error you're getting?

[Bhujanga]

Are you using Access 2003? In 2003 I use Me.TabControlName and it returns the page number.

What is the error you're getting?

I'm using 2003.
I typed this in:
Private Sub TabCtl59_Change()
x=Me.TabCt159
Msgbx x
End Sub

It said:
Compile Error: Method or Data Member not Found
"Me.TabCt159" is highlighted when I go to Debug.

[Rabbit]

I'm using 2003.
I typed this in:
Private Sub TabCtl59_Change()
x=Me.TabCt159
Msgbx x
End Sub

It said:
Compile Error: Method or Data Member not Found
"Me.TabCt159" is highlighted when I go to Debug.

You have 159, it should be L59.

[missinglinq]

Replacing

Msgbx x

with

Msgbox x

would probably help, too! But when I use Rabbit's code in ACC2003 it simply returns the tabbed control's name, not the page.

This will identify the page that was just clicked:

Private Sub YourTabbedControl_Change()
If Me.YourTabbedControl.Value = 0 Then ‘First Page
  Msgbox "Page 1"
ElseIf Me.YourTabbedControl.Value = 1 Then ‘Second page
Msgbox "Page 2" 
ElseIf Me.YourTabbedControl.Value = 2 Then ‘Third page
Msgbox  "Page 3"
End If
End Sub

Notice that it's zero based. The first page returns zero, second page returns 1, etc.

Linq ;0)>

[Bhujanga]

Thanks. Changing the "1" to an "l" did the trick.

[Rabbit]

Not a problem, good luck.