Solved

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

Posted on 2013-12-20
4
1,204 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:Gregory Miller
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:
Gregory Miller 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:Gregory Miller
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

730 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