CurentUser as a default value in a field

[IanMilly]

Hi

I want to have the CurrentUser being set as the default value in a textbox. the control source of the text box is called "SignedBy" , I want users to be able to change the name in the text box from that of the logged in user (as people may work in a group of 2 people when using the form or forms maybe edited in part later)

I want to place the CurrentUser function as the default value. Access won't let me do this.

I can use Environ("Username") to do this, but this records the user of the computer and not the logged on person to the database.

I am using access security to set level of user securities.

Sorry if surrentuser has been done to death -but no-one seems to want to save who the user was in any tables (in my case the field "Signedby")

Thanks

Ian

 

[WayneRyan]

Ian,

Did you set the DefaultValue property to =CurrentUser()?

Wayne

 

[IanMilly]

hi wayne,


Yes, I set the default value to =CurrentUser() in the table. However when trying to save this, it says that it is an unknown function as the default value.

I can set it using Environ("Username") but this is the computer logon and not the Access db logon name.

Any ideas? (I am using Access 2000)

Thanks

Ian