Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-12-20
4
Medium Priority
?
1,283 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 12

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 12

Accepted Solution

by:
Gregory Miller earned 2000 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 12

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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
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 …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

571 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