Using a Tab Control

[Guest]

Hi. I am using a Tab control on a form. When I switch pages on the form using
the tab control, I would like that action to reset the record source for a
list box in the details section of the main form. But clicking on different
tabs in the tab control does not invoke the code. I've tried putting the code
in the tab control under "click" event but nothing happens. What am I doing
wrong? Thanks for any help.

 

[John Vinson]

Hi. I am using a Tab control on a form. When I switch pages on the form using
the tab control, I would like that action to reset the record source for a
list box in the details section of the main form. But clicking on different
tabs in the tab control does not invoke the code. I've tried putting the code
in the tab control under "click" event but nothing happens. What am I doing
wrong? Thanks for any help.

The Click event of a Tab control is pretty useless - it fires when you
click onto the background surface of the tab page. Use the tab
control's Change event instead - it fires when you Change pages.

John W. Vinson[MVP]