disable field/control on form (dependent on user/group) jaworski_m 12/21/2008 4:29:01 PM 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.

Re: disable field/control on form (dependent on user/group) "Joan Wild" <jwild[ at ]nospamtyenet.com> 12/21/2008 4:34:29 PM 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" <jaworskim[ at ]discussions.microsoft.com> wrote in message news:F0D78CCD-09F0-4510-9129-0C5A4A911C6A[ at ]microsoft.com... [Quoted Text] > 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. >