Log-in user information text box is not passing into table

[nrmarthi]

Hello experts

good morning. here comes my doubt. i use =CurrentUser() in text box of form. but when am testing, the user name is not there in database.

i am using Access 2003 and Access security.

Can anyone tell how to resolve this

Thanks you

 

[ghudson]

Where are you storing the value? In a table [use an update SQL to do it] or as a global string [risky].