Active Tab control

[mtompkins]

Sorry for this one - just can't remember.

I need to detect which of 3 tabls is current the active tab -

Can someone kick start my memory please.

For example -

If Me.TabCtl0.Pages(1).setfocus = True

But this doesn't work - as I knew it wouldn't

Thanks.

 

[KevCon]

I'm thinking you might want to try coding the OnClick event of each page to pass a value to a hidden field, and go from there...

 

[KevCon]

OK, sorry, I meant to say the OnChange event of the tab itself

 

[Remou]

Hi
Did you mean as returned by (?):
MsgBox Me.TabCtl0.Pages(Me.TabCtl0.Value).Name

 

[mtompkins]

That'll work - thanks Remou!

 

[mtompkins]

2nd half -

I need to reference this from the report so I can't use Me...

I've tried:

Forms!frmMenu.Form.TabCtl0.Pages(Forms!TabCtl0.Value).Name = "Page1"

and I know I'm close -

Please help.

Thanks.

 

[Remou]

Hi
If I create a report with two text boxes (bit lazy with naming here) ...
Text0
=[Forms]!form1!tabctl0.Value
Text1
=[Forms]![form1]!tabctl0.Pages([Text0]).[Name]

When I select Page 1 of TabControl0 on Form1, Report Text0 = 0, Text1 = Page1

 

[mtompkins]

Perfecto! - thanks again