Dear fellow users,

I hope you can help me and I'm not convinced that I have posted this in the right place.

I want to have a form that will allow the end-user to input daily data about salespeople by department. So I decided to have a tab for each department and then as that department was selected it would display the relevant staff member and their sales so far. I've tried to use the 'on click' event procedure to filter the staff list but when I use the tab it doesn't call the function.

Is it possible to call event procedures when the tab is clicked (in the same way as with a command button), it ought to be. If so what might I be doing wrong?

Thanks for you help

Charlie

There is an event you can use its the OnChange of the Tab Control itself (Not the pages)

In order to run the code you want though you will need to do something like this:

Select Case Me.[TabCtrl].Value 'This is the Ordinal index of the pages
Case 0: Msgbox "I'm Page 1"
case 1: Msgbox "I'm Page 2"
Case 2: Msgbox "I'm Page 3"
End Select