Switch Between Tabs in Navigation Form

[ahd2008]

Good day all,

Can anyone enlighten me on how to switch between tabs in navigation form? My navigation form has 5 tabs, and for some reasons I need a code to switch, between those tabs.

I have searched the web, but unfortunately nothing worked out.

Thanks

[NeoPa]

I don't use tabs (or Pages) much, but I suggest you do select a control found on it to switch to it. Like Sections, I'm not aware of any way to switch focus to them directly (without selecting a specific control on them).

[ahd2008]

Thanks so much for your response; I appreciate your suggestion. However, can you tell me how to do select control found or how to implement your suggestion ?

Any idea will be much appreciateled

[NeoPa]

Rather than spelling out the details in the answer, that you should include in the question, I'll wait for some sensible details and reply using those if you don't mind. It's not fun working blind at the best of times, but completely blind because you haven't included any details in your question is not how things should be ;-)

[ahd2008]

Thanks Neopa for you kind support. Yes, you are totally right; I should have included more details.

Well, as stated in my first post I have a navigation form that has 5 tabs. The navigation form’s name is "ManageProfiles", and the tabs' names in order are:

1-EmployeesProfile
2-EvaluatorsProfile
3-MentorsProfile
4-Registration
5-WorkingSchedule

On clicking on WorkingSchedule tab, I navigate to the "WorkingSchedule Form" which is embedded in the navigation subform. It allows the user to see the schedule of each employee and their courses as well. Now, I need to write a code so when user clicks on a certain course, it switched directly to the Registration Tab, and filter through the records to bring up that particular course to allow the user to change the date.

The question now is how to switch to Registration tab?

Thanks in advance

[NeoPa]

Much better, BUT...

If you want code to switch to the [Registration] tab, then you need to include the name of a control that is found on that tab. A SubForm control is fine, but whichever control you choose will be selected when the switch is made.

You also need to include details of what it is that will trigger the code to run. If that is a click somewhere, then the name of the somewhere must also be included. It's a good idea to indicate names within []. It's not always necessary, but it does indicate clearly what is actually the name and what is part of your text.

[Mihail]

TabControlName.Pages("VBA_PageName").SetFocus

or, using pages indexes,

TabControlName.Value = IndexValue

[ahd2008]

Neopa Thanks for your usual support. I have tried all methods of finding a control on the [Registration] tabs, but nothing worked out. Luckly, while searching the web, I found a post in a forum similar to my case. I found out that the way to switch from one tab to another in "Navigation Forms" is to change the SourceObject of the Subform Control. So, the code to carry out this task is:

Forms![ManageProfiles].[SubNavigation].SourceObject = "EmployeesCourses"

Note: [EmployeesCourses] is the form embeded in Subform Control of Navigation Form.

Again, Thanks for your help

[ahd2008]

Mihail, Thanks for your inputs. I believe your codes would work with on forms based on Tab Control, but not with navigation forms.

Thanks all

[NeoPa]

I'm confused. Your solution doesn't fit the question at all as far as I can see.

I guess (from what you have now included in your answer) that the subform control found on the tab (Page) in question is actually called [SubNavigation] (My question #1). As such, my answer would have been (due to the lack of an answer to question #2 I can't illustrate this in context) :

Call Me.SubNavigation.SetFocus()

It may well be that Mihail's answer, if it works, is actually a better one anyway. I was under the impression that Tab controls could not be selected directly. Possibly I was confusing this with the fact that a reference to a control within a Tab doesn't need any reference to the Tab's name in it.

If, as seems possible now, you were really after a way of changing the form that's shown within a subform on your main form, then your solution should be :

Me.SubNavigation.SourceObject = "EmployeesCourses"

[Israel h]

Try This:

DoCmd.BrowseTo ObjectType:=acBrowseToForm, _ 
               ObjectName:="EventDS", _ 
               PathToSubformControl:="Main.NavigationSubform", _ 
               WhereCondition:="", _ 
               Page:="", _ 
               DataMode:=acFormEdit

[zmbd]

Just because this thread popped up:
A few other threads about this control - for those that come across this thread - dealing with a few different issues:

• Move to Tab in the V2007-V2010 Navigation Control
• Navigation form in Access 2010 producing error first time a different tab is clicked
• Generic Forms for Use in New Navigation Control
  >>THis will show you just how bad a lot of the reference material available on this control was (and to a great degree still is) when trying to learn the control. Also a simple solution to a complex question.
• How do I update textbox on Mainform on close of dialog window?
  >> A work around for something you might run into, just keep this handy... it also has a few other links.
• Navigation Control - Subforms
  >>Read post #2 and Post#4 - I really should merge these two (^_^)

[kcbehnet]

Me!NavigationSubform.SourceObject = "FORM NAME"

FORM NAME = the page you want to open in the subform area of the Navigation form

[zmbd]

kcbehnet
Me!NavigationSubform.SourceObject = "FORM NAME"

kcbehnet
You will find that only works {as expected} in a tabbed form control {the code in an ACC2010 navctrl results in a fresh reload of the subform; thus the info in the prior form is lost an as writen doesn't work from within the subform}

This will not work in the new ACC2010/newer NavigationForm Control {as one would expect. The original question was modified in post #5}

The way to move from one NavigationFormControl-tab to the other {and have the data filted as requested in post #5} is to use the "DoCmd.BrowseTo" method.

Please refer to the links as provided in my prior post for more detail about the newer ACC2010/newer NavigationForm Controls. (^_^)

[twinnyfo]

Z, et al,

For this reason, I started this thread: Is there any Value in NAvigation Forms?

I originally thought about posting a response to this thread, but began a new one.

Z, for you to have been frustrated understanding the new Nav Forms, I know they are not for me! I'm happy loading all my subforms at once into a Tab Control and being able to keep all my data!

:-)

[kcbehnet]

I place the following code in the Form_Load event of the Navigation form and it works.

Me!NavigationSubform.SourceObject = "FORM NAME"

As mentioned, I have two Navigation Controls, "NavigationControTop" and "NavigationControLeft". I am not sure if this is a tabbed form or normal navigation form as it is created automatically by selecting the Navigation Form Wizard.

I am sure I can solve the issue by means of one of the two following method:

First: if I can manage to activate the selected Navigation button in the "NavigationContyroTop".

or

Second: If I can know how to refer to the five respective groups in the "NavigationControLeft" control, with respect to the five navigation buttons in the "NavigationControTop" control.

[zmbd]

kcbehnet:
1) Well, if you used the wizard, then you most likely have the "Navigation Control"
2) Which version of access are you using?
3) Your solution of Me!NavigationSubform.SourceObject = "FORM NAME" does work as a solution to the original question as posted in #1 - provided the controls are on the main form or in the main form events.
4) I should have been clearer in reply (I will fix that after this post}:
The original question was modified in post #5(which I most likely should merge with post number one).
Your solution is already profered in post #8; however this shows the full form reference for a control within the subform and could have been shortened to:
Parent!NavigationSubform.SourceObject = "FORM NAME"
However, this code does not answer the modified question from post #5 which was to be able to pass information from one form to the next during loading of the next form. Post 11 by "Israel h" provided the solution that allows one to easily switch navigation control tabs and pass information between them.
5) You will find issues having VBA code in the main form of a navigation form. Especially if you are using a multi-tiered form (which it sounds as if you are) as demonstrated in this thread: http://bytes.com/topic/access/answer...nt-tab-clicked
This is a known bug in ACC2010 and has not been fixed as of yet for this version. I suspect that ACC2013 suffers from this as well.
6) You will need to start your own thread for what apears to be the questions about navigating to the secondary controls.
6a) Post 11 has one answer to your questions.