Solved

MS Access 2013--Using Form-Control Buttons to Open/Display Specific Navigation Tabs

Posted on 2013-12-20
4
1,176 Views
Last Modified: 2013-12-21
Attached is a sample from my DB.  Using the ‘Navigation Form (Form),’ here’s what I would like to happen:

‘Introduction (Tab):’
If ‘Start New Interview (Button)’ is clicked, open/display ‘Form1 (Tab).’

‘Form1 (Tab):’
If ‘Next (Button) is clicked:
--Open ‘Form2 (Tab)’ if ‘Onsite (Option Group)’ is selected
--Open ‘Form3 (Tab)’ if ‘Offsite (Option Group) is selected
 
If anyone can use real basic language and hold my hand through this process, it would be most appreciated.
Example.accdb
0
Comment
Question by:mdstalla
  • 3
4 Comments
 
LVL 11

Expert Comment

by:Technodweeb
Comment Utility
Here is the MS KB article to reference... http://msdn.microsoft.com/en-us/library/office/ff196381.aspx

I changed your code for the Click Event to:
Private Sub Command0_Click()
    DoCmd.BrowseTo acBrowseToForm, "Form1", "Navigation Form.NavigationSubForm", , , acFormEdit
End Sub

Open in new window


And on Form_Form1:
Private Sub Command13_Click()
    If Me.Frame21 = 1 Then
        DoCmd.BrowseTo acBrowseToForm, "Form2", "Navigation Form.NavigationSubForm", , , acFormEdit
    ElseIf Me.Frame21 = 2 Then
        DoCmd.BrowseTo acBrowseToForm, "Form3", "Navigation Form.NavigationSubForm", , , acFormEdit
    End If
End Sub

Open in new window


The back button needs to be made to use code similar to Command0 Click Event else you get a new form and all code is relational from the navigationsubform
0
 
LVL 11

Accepted Solution

by:
Technodweeb earned 500 total points
Comment Utility
Sorry I had to do a quick edit. I pasted an incorrect line the first time but it is correct this time.
Example.accdb
0
 

Author Closing Comment

by:mdstalla
Comment Utility
This dude is a bad-ass!  He solve a problem I've been stuck on for days in seconds.  Major pts. to this guy and thanks for all your help!  Keep an eye out for me because I may need more help.  Merry Christmas, Buddy!
0
 
LVL 11

Expert Comment

by:Technodweeb
Comment Utility
This was my first exposure to the Navigation Form control and it is a little odd to understand at first so I can understand why you were a stuck. Anyway, thanks for the comments...
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
My experience with Windows 10 over a one year period and suggestions for smooth operation
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

744 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

14 Experts available now in Live!

Get 1:1 Help Now