What is the best Event to use for.... (1 Viewer)

M

music_al

Registered User.

Local time

Today, 16:16

Joined

Nov 23, 2007

Messages

200

• Oct 31, 2018

• #1

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

AWF VIP

Local time

Today, 09:16

Joined

Jul 2, 2005

Messages

13,826

• Oct 31, 2018

• #2

I would use the Change event of the TabControl.

 

Ranman256

Well-known member

Local time

Today, 11:16

Joined

Apr 9, 2015

Messages

4,339

• Oct 31, 2018

• #3

yep...change

 

Minty

AWF VIP

Local time

Today, 16:16

Joined

Jul 26, 2013

Messages

10,368

• Oct 31, 2018

• #4

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

AWF VIP

Local time

Today, 20:46

Joined

Jan 20, 2005

Messages

735

• Nov 1, 2018

• #5

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