Wendell,

When I made the change to add suser_sname() as the default value for the field it works well only from my system.

If I launch the access file from another user's system the field does not populate. I have tried setting the user's having the issue in the db_owner role for the database but the same thing still occurs.

Is there a specific permission that needs to be set in order to enable the user updating or adding a record on the form?

Also my system is running access 2013 with sql server 2012 native client odbc driver. The user systems have access 2010 running sql server 2008 R2 native client odbc driver.

Please let me know what you think.