VBA UserGroup Variable

[Jezzyjez]

What is the variable name for the value of the usergroup name for example:

If Usergroup = "Admin" Then
MsgBox ("Test")
End If

I have just put Usergroup in as the variable name but this does not work
what name should be used?

 

[Douglas J. Steele]

Are you saying that you're trying to determine the user group to which the
current user belongs? There's no such function, since a user can belong to
more than one group.

See
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp#_Toc493299691
to determine whether or not a user belongs to a particular group, or return
a lists of all of the groups to which the current user belongs.

 

[Jezzyjez]

Ok i get where your coming from there, what i need to achieve is when people
from user group A log in frmA opens, and when people from user group B log in
frmB opens so i have created a macro to be run on startup with simular code
as to shown below but this obviously doesnt work

 

[Douglas J. Steele]

Did you bother checking the reference I gave?

You can use

If faq_IsUserInGroup ("Admins", CurrentUser) Then
MsgBox "Test"
End If

 

[Jezzyjez]

Neither MSysAccounts or MSysGroups appear when I show system objects??