Display domain user into form

[kevinv]

Hi,

I am currently working on small access 2010 database where the database consists of a table and one input form. This input form will be mainly used by two persons. In the form there is a dropdown where one selects his name to keep record who entered the data, however I would like this to be according the logged in domain account. This will make sure none of them selects the wrong user by mistake.

Is there a way how get the current logged on domain account into the form ?

Thanks,

Kevin

 

[pbaldy]

The Environ() function or this:

http://access.mvps.org/access/api/api0008.htm

 

[kevinv]

Hi Paul,

Thanks for your reply. I have seen the post in your reply however could not make it to work. I created the module as indicated and saved the module. Then in the form I've selected the field where I want the username to appear and in the default value I mapped to the module, however it returns, #Name?

Thanks,

Kevin

 

[pbaldy]

Make sure the module and function don't have the same name, and you'd call the function, not the module:

fOSUserName()

 

[kevinv]

Thank you very much Paul, It worked as intented.

 

[pbaldy]

No problemo!