Solved

Navigation Form and setting focus on a tab

Posted on 2014-12-12
5
82 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
  • 3
  • 2
5 Comments
 
LVL 84
Comment Utility
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
Comment Utility
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 84
Comment Utility
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
Comment Utility
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
Comment Utility
Because I was able to figure out the coding on my own.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now