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

 

[Pat Hartman]

CurrentUser() is the name of the function but I don't think you can use it in a table default. The only functions you can use here are those which exist within SQL and even then few are allowed.

I set the lastUpdateBy and LastUpdateDate in the BeforeUpdate event of all my forms. It would be nice to be able to do it in the table def, oh well, mabe if Microsoft decides to put new life into Jet we'll see this capability in Jet 10.