How to detect change of tab control page

Access 2003

I have a two-page tab control with subforms on each page. I need to run code when the user selects a tab page. The tab page On Click event fires when the body of the tab page is clicked, but I can't get it to fire when the tab name is clicked. I've also tested this with a blank tab control on a blank form, with the same result. So how do I run code at the point the user selects the page?
SteveCondAsked:
Who is Participating?
 
rockiroadsConnect With a Mentor Commented:
Booze just the last two days unfortunately, Ive had this damn cough I couldnt get rid of so ruined it a bit, otherwise was good. And of course good footy at the weekend.

Glad you got it going
0
 
rockiroadsCommented:
just to confirm, is this form developed using visual studio or msaccess?
0
 
SteveCondAuthor Commented:
Beg pardon - brain not in gear yet after the Bank Holiday! I meant to put it just in the msaccess area. I also accidentally gave it 500 points - but I'll let it go at that (Happy Easter.....)
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
rockiroadsCommented:
Trust you had a good Easter, nice long weekend :)

Try using the On change method instead
0
 
SteveCondAuthor Commented:
Wonderful time thanks - but too much booze! Yourself?

On change works a treat. Thanks!
0
 
SteveCondAuthor Commented:
Shame about the cough!
0
 
rockiroadsCommented:
thanks buddy, good luck with the rest of your project
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.