Tab Control

[ikayser]

Hi,

I am using a tab control in Access 2002. I cannot manage to get the
page click event to fire when i click on a page.

Can anyone point me in the right direction?

ikayser

 

[Guest]

Try this for determining the current page after the user has clicked on a tab:

Place the following code in the "OnChange" event of your tab control.

If Me.NameOfTabControl.Value = 0 Then
MsgBox "page8"
Else
MsgBox "page9"
End If

You will need to change the value (index value) being evaluated if you do
not have a page with a zero index. Also you can change the message to be
displayed.

 

[Linq Adams via AccessMonster.com]

The OnClick event for a tabbed page is only triggered by clicking *on the
page itself* not the tab for the page! It's also quirky in that clicking on
the page itself won't trigger the event IF the tabbed control's Back Style is
set to "Transparent" (as you would set it if you want it's background color
to be the same as your form's detail section) rather than "Normal."

Mr B's hack is the best work around for this problem.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com