Getting active tab name from a form?

[techexpressinc]

I need to get the active tab name from the form?

TxtQueryVarible = Me.TabCtl14
   MsgBox TxtQueryVarible, vbOKOnly, "Confirmation...  "
This tells the tab i am at is index 0

Thx
Russ

 

[boblarson]

This instead:

Dim strTab As String
 
strTab = Me.TabCtl14.Pages(Me.TabCtl14).Name
 
MsgBox strTab, vbOKOnly, "Confirmation...  "

 

[techexpressinc]

Bob - you are a genius! When it comes to Access.

Russ