Solved

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

Posted on 2013-12-20
4
1,187 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

912 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

16 Experts available now in Live!

Get 1:1 Help Now