Linking the value of a feild to CurrentUser()

[Guest]

I have a table with fields [usernm] and [password] and a form with
corresponding text boxes (txtusernm and txtpassword) which allow the user to
enter the database if the password and user name match up with corresponding
values in the table. However. I would like the user name that is selected to
correspond to the currentuser(). That is if "John Doe" is selected in the
form I would like CurrentUser() to equal "John Doe". Is there a way to do
this? This is very important as different users will have differnent
privileges. Thanks in advance for any help.

 

[Douglas J. Steele]

The value returned by CurrentUser cannot be manipulated. It's the id that
was used to log into the application (or "Admin" if Access user-level
security hasn't been applied).