?
Solved

Navigation Form and setting focus on a tab

Posted on 2014-12-12
5
Medium Priority
?
89 Views
Last Modified: 2014-12-17
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
Comment
Question by:lrollins
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 85
ID: 40496347
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
 
LVL 1

Author Comment

by:lrollins
ID: 40496384
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
 
LVL 85
ID: 40496392
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
 
LVL 1

Accepted Solution

by:
lrollins earned 0 total points
ID: 40496863
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
 
LVL 1

Author Closing Comment

by:lrollins
ID: 40504378
Because I was able to figure out the coding on my own.
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question