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.
Code:
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.