Basically what I'm trying to do is DoCmd.OpenForm ("frmname"), acNormal, , , , acWindowNormal, variable & ";" & variable2 which works fine for forms that are pop-ups.
The problem I'm having is that on a navigation control, if I do the same thing, it doesn't go to the tab the sub form is on, it opens it in another window.
I was trying to code something like a button's On_Click event from one tab in the Navigation Control to open another tab and pass a variable from the first form through.
I saw something about acBrowseTo but I couldn't get it working or find much information on how exactly a path like mine would look when I'm trying to pass a variable from the first form.
Any help?
The problem I'm having is that on a navigation control, if I do the same thing, it doesn't go to the tab the sub form is on, it opens it in another window.
I was trying to code something like a button's On_Click event from one tab in the Navigation Control to open another tab and pass a variable from the first form through.
I saw something about acBrowseTo but I couldn't get it working or find much information on how exactly a path like mine would look when I'm trying to pass a variable from the first form.
Any help?