• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 92
  • Last Modified:

Navigation Form and setting focus on a tab

I have a navigation form setup called Home Page.  It has 5 tabs in the navigation subform.  Tab 5 has two navigation buttons (vbutton1 and vbutton2) which refer to different subforms (vbutton1 > frmcheck and vbutton2 > frmMultiFilter).

On frmcheck there is a button that I have a code behind that asks for the Job number and then runs a macro and pulls the necessary records related to that job.  It was fine but what I want it to also do is after the the macro has run then it will switch to frmMultiFilter under vbutton2 automatically.

Any ideas?
0
lrollins
Asked:
lrollins
  • 3
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do you mean you want to show frmMultiFilter after you've pulled in the Job records? If so, then do this in the Load or Open event of frmcheck:

DoCmd.OpenForm "frmMultiFilter"
0
 
lrollinsAuthor Commented:
I don't want it to open the form separate from the navigation form.  I want it to switch in the navigation form.  I've included a screen shot that shows the Visual Check with the button and then the Lot ID with the multifilter form.  These are under the same tab.
navigation.doc
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You could perhaps call the Click event of the second button after the first has run. I'm not sure how to do that with macros, but in code you'd do this:

Call YourButtonName_Click()

That would run whatever code is in the Click event of "YourButtonName"
0
 
lrollinsAuthor Commented:
I finally figured it out....   Here's the code I used...

DoCmd.BrowseTo acBrowseToForm, "frmMultiFilter", "Home Page.NavigationSubForm"

frmMultiFilter is the form I want to open

Home Page.NavigationSubForm is where it's contained.
0
 
lrollinsAuthor Commented:
Because I was able to figure out the coding on my own.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now