REFERENCING A TAB PAGE

[Tru Dixon]

Having the damnest time trying to reference a tab control
page.

Tried these commands:

1) Dim pge As Page
Set pge = tabEEInfo.Pages(1)

2) Set pge = tabEEInfo!tabPersonal

3) Me!tabEEInfo("tabPersonal")

Each time I get this error message "Run Time Error '13'
Type Mismatch.

I can't believe I am having this much trouble.

 

[Guest]

-----Original Message-----
Having the damnest time trying to reference a tab

control to change the page or tab page.

 

[Arvin Meyer]

Try this:

Private Sub TabCtl1_Change()
MsgBox "Clicked Tab# " & Me.TabCtl1 + 1
End Sub

The index is zero based, hence the addition of 1
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access