Navigation Form/Sub Form Question

jcruzAME

Registered User.
Local time
Yesterday, 22:01
Joined
Oct 5, 2011
Messages
135
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?
 
Found a fix. Setting focus on an object on the main form and then running the code works.
 

Users who are viewing this thread

Back
Top Bottom