Tab page event

[Rajesh99]

I want to processs some code when tab page is selected. I used 'On Click' event that seems to work fine if I click in the middle of tab page. But users will click on the little thumb nail to select a tab and this event does not seem to fir at that time. What other things can I do to accomplish that considering that users may even not use a mouse to select a tab, they may us a key stroke..

 

[PaulF]

use the Tab Control's On Change Event and check the Tab Control's value, it will return the Page Index #

PaulF

 

[Rajesh99]

Any other way, seems if someone goes and inserts a new page in there this may break the code as index will vary?

 

[TheAceMan1]

How are ya Rajesh99 . . . . .

Yoyu don't have to worry about the Tab Index, thats another line of code.

[blue]The [purple]Change Event[/purple] occurs when you move from one page to another page[/blue]

Perhaps if you explain what your code accomplishes, we can better advise/serve you . . . . .

See Ya! . . . . . .

 

[Rajesh99]

Thanks. The code really inserts a record in a database table, every time someone goes to this tab. I have a tabbed form tha holds a number for form in each tab page. Looking for a way to do this in access, if possible without hardcoding any tab index # etc.