Creating Users

[didacticone]

I have used the user-level security wizard to set up users and permissions. This is working great but i was wondering if its possible to display a form for a specific user. for instance if user "A" logs in, can i have it automatically open form "A" and user "B" form "B" and so on? thanks for your help.

[Lysander]

You can use the CurrentUser function in your startup code.
e.g.

if CurrentUser="Lysander" then
     docmd.openform "frmLysander"
else
  etc
 

or, if you have loads of users, name the form after the user name and do this

dim strString as string
strString="frm" & currentuser
docmd.openform strString
 

If you are putting your users into groups (always recommended), then you can use the funcion ismemberof

I use that below, to display certain options to certain groups

tabAdmin.Visible = ismemberof("superAdmin")
tabEdit.Visible = ismemberof("Administrator")
bDisableBypassKey.Visible = (CurrentUser = "Owner")