Do you have this posted elsewhere? I could swear I answered this, somewhere (I currently troll along in this and five other Access forums) yesterday! And in going into Word, I found that yesterday I had, indeed, accessed this little tutorial I post when the question comes up! Anyway:
The first thing to understand is that Tabbed Page Index is Zero-based, i.e. the first page has a value of 0, the second page has a value of 1, the 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 YourTabbedControlName_Change()
Select Case YourTabbedControlName
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
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007