Solved

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

Posted on 2013-12-20
4
1,194 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
ID: 39733200
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
ID: 39733203
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
ID: 39733212
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
ID: 39733477
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

813 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