Tab Control macro not triggering

Question

I have a Tab control on a form in Access. A Private sub for the On Click event for the page works for the first page (Page Index 0). But the the Private sub for the On Click for other Pages on the tab control is not recognized in code. Any Ideas?

Private Sub Page1_Click()
'This works (Page Index 0)
MsgBox ("Hi!")
End Sub

Private Sub Page2_Click()
'This doesn't (Page Index 1)
MsgBox ("Hi!")
End Sub

Answer 1

Hi,

You must click on the "body" of a tab page to trigger its click event. If instead you want to react to the click on the tabs, you can use the Change event of the tab control like this

Select Case MyWonderfulTabControlName
Case 0
MsgBox ("Hi first tab/page!")
Case 1
MsgBox ("Hi second tab/page!")
Case 2
'etc.
End Select

Servus
Karl
Access Bug Trackers
Access News
Access DevCon