Solved

Navigation Form and setting focus on a tab

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Replacing an Access Error with a Custom Message 3 28
ORDER BY 7 36
Delete records based on common identifier from third table 2 28
Convert VBA UDF to SQl SERVER UDF 4 46
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

685 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