What is the best Event to use for....

[music_al]

I have a form that sits on a tab control. When I select the tab I would like the form and all the controls that sit on that form to requery, but what is the best Event to use in which to add the requery code ?

Ive tried Form...

Activate
Got Focus
On Current

...but none of them seem to work.

 

[RuralGuy]

I would use the Change event of the TabControl.

 

[Ranman256]

yep...change

 

[Minty]

The on change tab control event is what you want I suspect. That fires when the tab page is changed.

The form events you have listed will only fire when the form (subform remember) on the tab is actually used.

 

[apr pillai]

Some info about Tab Controls and Events:Set Focus on Tab Page Click