Have a specific form open based on user/ Is this possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our inventory db is currently secured and permissions applied based on the
specific user. However, my manager likes the current framework for admin
level users and doesn't want to change it. He did ask me if I could set it up
so when a standard user opens it, they only get one form within this db and
that is a data entry form. Is it possible to associate specific forms to open
by specific user or group?

Thank you to all in advance, your knowledge is greatly appreciated!
 
Yes, you can have a startup code that checks to see either who the current
user is (CurrentUser function), or checks to see if the current user is a
member of some group (code in the security FAQ)
http://support.microsoft.com/?id=207793

Then open the appropriate form. You could use an autoexec macro to run the
code or do this in the open event of a startup form.
 
Back
Top