disable field/control on form (dependent on user/group)

[jaworski_m]

Hello,
Is there a way to disable a field(s) on a form when a user from a certain
group is logged in (not a single user)?

If the function "currentUser()" is used, every time a new user is added vba
code must be modified which is not very convenient.

Thank you for suggestions.

 

[Joan Wild]

The security FAQ contains sample code for a function to see if the current
user is a member of a certain group.
http://support.microsoft.com/?id=207793