Take action based on open tab

[swavemeisterg]

Is it possible to use the focus of a tab group as a criteria for an If statement?

For example, I have three tabs, and I want to run three portions of code depending on which tab is open. I know that I could use buttons to do this, but I'd rather just use the built in tabs. Any one know if this is possible?

[Missinglinq]

You need to use the Tabbed Control's OnChange event; here's a quick tutorial on the subject:

*********************

The first thing to understand is that Tabbed Pages are indexed starting with zero, i.e. the first page has a value of 0, second page has a value of 1, third page has a value of 2, etc.

Secondly, you need to understand that the OnClick event of a Tabbed Page only fires when you click on the page itself, not the tab at the top of the page!

Lastly, you need to understand that the Tabbed Control change event fires anytime the Tabbed Pages change. But to base something on the change event, you have to identify the particular page that has focus.

Private Sub YourTabbedControl_Change()
  Select Case YourTabbedControl 
	Case 0  'First Page 
	  'Code for Page 1 goes here
	Case 1  'Second page 
	  'Code for Page 2 goes here
    Case 2   'Third page
 	  'Code for Page 3 goes here
  End Select
End Sub

*********************

Linq ;0)>