Solved

Navigation Form and setting focus on a tab

Posted on 2014-12-12
5
84 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
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 84
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

803 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