Detecting subform focus

[Keith Wilby]

I have a form with 4 subforms on a tab control. How can I detect which
sub/tab has the focus from the main form?

Many thanks.

Keith.

[Allen Browne]

Examine the ActiveControl of the main form to determine what control has
focus, e.g.:
Debug.Print Me.ActiveControl.Name

Examine the Value of the tab control to determine which page is currently
selected, e.g.:
If Me.Tab1.Value = Me.Page2.PageIndex Then ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Keith Wilby" <he**@there.comwrote in message
news:45**********@glkas0286.greenlnk.net...

>I have a form with 4 subforms on a tab control. How can I detect which
sub/tab has the focus from the main form?

Many thanks.

Keith.

[Arno R]

Hi Keith,

If Me.TabControl = 0 then the first page(tab) of your tabcontrol is the active one
If Me.TabControl = 2 then the third page(tab) of your tabcontrol is the active one
So check the value of your Tabcontrol.

Arno R
"Keith Wilby" <he**@there.comschreef in bericht news:45**********@glkas0286.greenlnk.net...

>I have a form with 4 subforms on a tab control. How can I detect which
sub/tab has the focus from the main form?

Many thanks.

Keith.

[Keith Wilby]

"Arno R" <ar***********@tiscali.nlwrote in message
news:45**********************@text.nova.planet.nl. ..

Thanks guys.

Keith.