By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,965 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,965 IT Pros & Developers. It's quick & easy.

identify pressed tab on the cotrol tab

P: n/a
Hi

is there a way to indentify the tab that was pressed on the tab
control via VBA?
the prefered way if via the function of the tab control and not via
the page
Oct 3 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Examine the Value of the tab control.

It will match the PageIndex of one of the page controls.

Example:
If Me.MyTabCtl.Value = Me.Page99.PageIndex Then
MsgBox "You're on page 99."
End If

--
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.

"thread" <ya******@gmail.comwrote in message
news:2d**********************************@i76g2000 hsf.googlegroups.com...
Hi

is there a way to indentify the tab that was pressed on the tab
control via VBA?
the prefered way if via the function of the tab control and not via
the page
Oct 3 '08 #2

P: n/a
And this is done in the Tab Control's OnChange event, not the OnClick event.

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

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Oct 3 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.