Undefined Function Error 1

[mkallover]

I have two users that test database changes for me and they're both getting an error with an MDE file that I can't replicate. The error centers around a function that I have to save a chosen option in a drop-down list as the default. When they click the button it calls a basic query:

UPDATE tblUsers SET MainQuery = Forms!frmMain!Display
WHERE UserID = Environ("Username");

This works just fine for me. However, when I send the MDE to them they both get this error:

The expression On Click you entered as the event property setting produced the following error:
Undefined function 'Environ' in expression

I use that function in several other places without any problems but I don't think I actually use it in a query. Is that is what is causing the problem?

 

[dhookom]

I wouldn't use the Environ() function since it has integrity issues. Try use fOSUserName() found at [link

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

]API: Get Login name[/url]

Duane
Hook'D on Access
MS Access MVP

 

[mkallover]

Ahhh, that seems to have done the trick.

Thanks dhookom!