Navigation forms DoCmdBrowse

[silbi]

Hallo,




I’ve problem with the new navigation functionality in Access 2010.


My database is an administration tool for trainees, where I collect all the performance data of all trainees. There are 3 access roles for the tool. For this example I explain the role of the trainee coach.

...continuing in my attached document (zipped pdf), where you can also see screenshots for better explanation.

silbi


Access2010_DoCmdBrowse.zip

[silbi]

Hallo,

I’ve a problem with the new navigation functionality in Access 2010.
My database is an administration tool for trainees, where I collect all the performance data of all trainees. There are 3 access roles for the tool. For this example I explain the role of the trainee coach. He should have only access to the navigation tab “Abteilungen”, because there he can enter the performance data of each single trainee, which has worked in his department.
The database has not the final look, because in the programming phase I want to see all the changes.
It starts with the login screen. Mr. Müller is a trainee coach, enters the password and clicks “OK”.



1: Login screen

What should happen? All tabs, except the tab “Abteilungen” should be inaccessible. Within the tab “Abteilungen” the trainee coach should see his form to enter the data.


2: data entering screen for trainee coach

What happens? All tabs, except the tab “Abteilungen” are inaccessible (good). The focus seems to be on tab “Abteilungen” (red marked). But there is always the form of tabs “Grunddaten | Auszubildende” visible and not the data enter form for the trainee coach.


3: data entering screen for trainee coach with wrong form

Attached I will show you my draft with all the names and captions:

Pay attention: Within the tab “Abteilungen” I have no second row of tabs!

And here is my code after checking username and password, determine the user role and making all the other tabs inaccessible:

DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="frmLeistungenAbteilung", _
PathToSubformControl:="frmNavigation.Navigationsun terformular>frmLeistungenAbteilung.frmLeistungenAb teilungUnterformular", _
WhereCondition:="", _
Page:="", _
DataMode:=acFormEdit

I’m pretty sure, that my problem is to define the right PathToSubformControl.