User name in the form

[tanglk]

I want to put in the username for any update.

I have this function in my modules:

Public Function Env()
Env = Right(Environ(35), 7)
End Function


I have this in my macro:
Set value
Item: [Forms]![frmH05]![Upby]
Expression: Env()

When the macro activated, the following error message come out:
"The expression you entered has a function that DB1 can't find"


I have not problem with another macro where
Expression: Now()

What should i do to rectify the error.

 

[Allen Browne]

Here is a more stable way to capture the user name:
http://www.mvps.org/access/api/api0008.htm