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.

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


--
Joan Wild
Microsoft Access MVP
"jaworski_m" <(E-Mail Removed)> wrote in message
news:F0D78CCD-09F0-4510-9129-(E-Mail Removed)...
> 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.
>