VBA quick question

[isaphrael]

I am trying to filter the selections made from a query on a form with
the tab control. In general there will be 2 or 3 results for the
query, and there are 3 tabs. The tabs have the same name as one of
the fields in the query, so the easiest way to filter would be to pull
the name of the tab in and apply a filter whenever the user changes
which tab is accessed. However, i am unable to grab the tab name
through VB, perhaps someone would be able to assist me?
-KB

[rkc]

"isaphrael" <id******@yahoo.com> wrote in message
news:54**************************@posting.google.c om...

I am trying to filter the selections made from a query on a form with
the tab control. In general there will be 2 or 3 results for the
query, and there are 3 tabs. The tabs have the same name as one of
the fields in the query, so the easiest way to filter would be to pull
the name of the tab in and apply a filter whenever the user changes
which tab is accessed. However, i am unable to grab the tab name
through VB, perhaps someone would be able to assist me?
-KB

You have to dig into the tab controls Pages collection.

Me.MyTabCtl.Pages(Me.MyTabCtl.Value).Name