Access 2010 Navigation VBA

[carl6885]

Hi

I have a DB at the moment that is making use of Navigation control. I guess this is alternative to a switchboard.

I have a tab that has features only a certain number of people can use. Restricting the access by user has worked but what I need to do is where they are not authorised it returns focus to a particular tab.

I have tried a couple of things: this is what I have at the minute but nothing seems to work.


DoCmd.BrowseTo acBrowseToForm, "Main Log", "frmNavigation.frmMainLog"

frmNavigation is the name of the form with the navigation control on.
frmMainLog is the name of the form which is shown when I select tab 1.

Any help will be appreciated

 

[carl6885]

Managed to solve it with a little help from Google.

Please see below for anyone that might be interested. In order to switch between the tabs in vba you need to do the following:

DoCmd.BrowseTo acBrowseToForm, "Name of form tab referencing", "Name of form when navigation control is.NavigationSubform"

I hope this might help someone.

Thanks

Carl