finding current usergroup

[Cereldine]

I have been doing some research on the currentuser() function and basing events on its value.

I have been testing around the following

If CurrentUser() = "manager" Then
Me.tabHide.Visible = True

End If

My understanding is that if a user called "manager" is logged in the tab will become visible.

What would i have to do if i wanted to make the tab visible based on the group a user is in rather than their log in name? e.g. bill and john are both managers that need to see that particular tab but have different usernames?

 

[Dave Eyley]

I have done this with a large database that is used for an Estates Facilities Office. There are, potentially, up to 35 users and they all have varying access rights to various facilities of the db.

I used a GetUser() function to get the Windows login name of the user and compared that with a username table. The table also has fields which indicate the group to which the login name belongs.

On testing the login name against the table you can do pretty much anything from there...

Hope this helps

Dave Eyley