Login name displayed on form

[dk]

I trying to know the name of database user entered new record in table
orders. ( FIELDS: OrderID,User,Date,ordertext)
When I use =CurrentUser() as control source for field "User" I get the
username of person logged to windows.( Admin).
How can I set this value to any user logged to database ( entered in form
USER).


Thank You all for help.

 

[Jonathan Smith]

I trying to know the name of database user entered new record in table
orders. ( FIELDS: OrderID,User,Date,ordertext)
When I use =CurrentUser() as control source for field "User" I get the
username of person logged to windows.( Admin).
How can I set this value to any user logged to database ( entered in form
USER).


Thank You all for help.

This is the DEFAULT Response, until you implement ACCESS SECURITY.