Solved SetFocus (1 Viewer)

[RevJeff]

Hi, I have a form with a Tab Control on it. I have 3 tabs on the Tab Control and I am trying to SetFocus to a specific Button on each Tab when I click those tabs, but it doesn't work. It's acting like every time I click those tabs it chooses a different focus on that tab.

I hope I explained that clearly. Any thoughts?

Thanks!

 

[theDBguy]

Hi. Can you please show us the code you're trying to use?

 

[Minty]

What code are you using and in what event?
You probably need to use the TabChange event, and also work out which tab you are on.

Also, check the tab order on the tab control, that might fix things for you.

 

[RevJeff]

I don't really have much code. I tried this on the On Click for the specific tab, which only works if you click on the body of the Tab, not the actual Tab at the top. I then set the Tab Order of the button on the Tab and that still didn't work.

Private Sub REPO_Click()

    Me.btnSelectFileREPO.SetFocus

End Sub

 

[Minty]

Like I said - with a Tab control you need the On Change event of the tab control, and you will need to know which tab page you have selected.
Tab controls aren't the most intuitive to work with Use something like

Debug.print Me.MyTabControl

To tell you which page you are on.

 

[RevJeff]

Like I said - with a Tab control you need the On Change event of the tab control, and you will need to know which tab page you have selected.
Tab controls aren't the most intuitive to work with Use something like

Debug.print Me.MyTabControl

To tell you which page you are on.

That worked perfectly! Thank you!

 

[Isaac]

Or, actually change the page. Me.TabControlName.Value=2 (then, set focus to a button on that tab)