Setting Default Value to Access User ID

[pmorris]

I am having some problems setting the default value of a field to the user name of the person logging on to the database.

I have created a *.mdw for my individual database and would like to include the current user id of the user creating a new record.

Anyone out there have any ideas how i would go about doing this?

 

[Mile-O]

What version of Access?

 

[pmorris]

Access 2000