Home All Groups Group Topic Archive Search About

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

Author
21 Dec 2008 4:29 PM
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.

Author
21 Dec 2008 4:34 PM
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


--
Joan Wild
Microsoft Access MVP
Show quoteHide quote
"jaworski_m" <jawors***@discussions.microsoft.com> wrote in message
news:F0D78CCD-09F0-4510-9129-0C5A4A911C6A@microsoft.com...
> 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.
>