security - user group

[Arlene McGowan via AccessMonster.com]

I need to restrict certain records from a group when they search for
records. Does anyone know how I can I identify the user's group?

 

[TC]

A user can be a member of /many/ groups.

This displays the name of each group to which the currently logged-on
user belongs:

for each g in dbengine(0).users(currentuser()).groups
msgbox g.name
next

HTH,
TC

 

[Arlene McGowan via AccessMonster.com]

I have only 3 groups and none of the users are in multiple groups. Thanks
you, i'll try it out.

 

[Arlene McGowan via AccessMonster.com]

Oops, I forgot everyone is in the users group

 

[TC]

If it is "possible" for a user to be a member of many groups, you
really should code for that case, even if you do not think it will
happen at first. This is called "defensive programming".

Cheers,
TC