cancel navigation button

[spinkung]

Hi

i have a navigation control (access 2010) and one of my button is 'admin'. I want to cancel the admin form loading if the user doesn;t have access.

To check access i do a lookup in a table on the click event of the nav button.

problem is that even when i exit the sub the admin form still loads. how do i cancel the request to load the admin form??

the button comes with the following..

Private Sub nav_02_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)


Thanks

 

[VilaRestal]

On the Open event of the Admin form you could check the permissions and Cancel = True if user doesn't have permission