Open form for current user

[Guest]

I want to open a form with a control only when a specific user is logged onto
the database. it must be possible but can't find a way - its driving me mad.

Any suggestions much appreciated

Pete

 

[Arvin Meyer [MVP]]

If you are using Access user-level security, the CurrentUser() function will
give you the name of that user:

If CurrentUser() = "Arvin" Then
DoCmd.OpenForm "frmWhatever"
End If

The same type of code will work if you capture the Windows username:

http://www.mvps.org/access/api/api0008.htm

 

[Guest]

Thank a lot Arvin I not so good at SQL so appreciate the help.
Pete