open tab in a form when double click field in subform

[megatronixs]

Hi all,



I have as subform inside a main form that has 2 tabs: "Search" and "Main"
In the subform I have the search results from the tab "Search". The idea is to open the tab "Main" when I double click.

I have the below code, but no clue where to get it to open the tab as it is all on the Main form.

Private Sub Account_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_main_form"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

Greetings.

[June7]

Not sure what you mean by 'open a tab'. You have a subform with a Tab control? You want code to set focus on a tab page called "Main"? If you want to provide db for analysis, follow instructions at bottom of my post.

[megatronixs]

Hi June7,
Yes, that is the idea, to set the focus on the tab control called "Main"

Greetings.

[megatronixs]

Hi all,

I got it solved :-)

I just added at the end:

Me.Main_tab.SetFocus

and it sets focus on that tab control :-)

Greetings.