Currently we have a function:
Function GotoClientTab()
On Error GoTo GotoClientTab_Err
DoCmd.BrowseTo acForm, "subfrmClient", "", "", "", 1
GotoClientTab_Exit:
Exit Function
GotoClientTab_Err:
MsgBox Error$
Resume GotoClientTab_Exit
End Function
When you double click on a client on the home tab (it's a list box), this code runs and it moves to the Client tab, which populates their assets and what not (not important).
The new sub form is a continuous form (which works better for what we're trying to do).
If I run this code from that sub form it will open the Client form in the sub form instead of switching over to he tab.
Is there a way to get around this, say running the code form the parent form somehow or something like that?
Function GotoClientTab()
On Error GoTo GotoClientTab_Err
DoCmd.BrowseTo acForm, "subfrmClient", "", "", "", 1
GotoClientTab_Exit:
Exit Function
GotoClientTab_Err:
MsgBox Error$
Resume GotoClientTab_Exit
End Function
When you double click on a client on the home tab (it's a list box), this code runs and it moves to the Client tab, which populates their assets and what not (not important).
The new sub form is a continuous form (which works better for what we're trying to do).
If I run this code from that sub form it will open the Client form in the sub form instead of switching over to he tab.
Is there a way to get around this, say running the code form the parent form somehow or something like that?