show/hide forms or tabs based on user login info

[Guest]

i have used the security wizard to setup user logins & p/w for my database, and am thinking about showing/hiding specific forms or tabs on forms based on the user login

i essentially want some named users to see a specific tab or form, and others not

is this something that can be done

would appreciate some guidance on this!

 

[Joan Wild]

If you've assigned permissions to groups (rather than to users), you can use
the function in the security FAQ to see if the current user is a member of a
group.

Use the last function in section 22 of
http://support.microsoft.com/?id=207793
faq_IsUserInGroup

In the Open event for your form

If faq_IsUserInGroup("Production", CurrentUser()) then
me!Tab.visible = false
Else
me!Tab.visible = true
End if

--
Joan Wild
Microsoft Access MVP

i have used the security wizard to setup user logins & p/w for my

database, and am thinking about showing/hiding specific forms or tabs on
forms based on the user login.