Current User is incorrect
Always learning
Windows 10 
Access 2016
Hello! Have a weird problem today, on the main form I have an unbound text box, "User", Control Source is "=CurrentUser()", but it is showing Admin as the current user which is incorrect. The user actually should be "HA4User", I tested it in the immediate window and got Admin. I checked Windows and saw HA4User. Anyone run into this before? I don't even know where to begin. TIA.
Virtually Inert Person
Windows 7 32bit Access 2007
I take it that CurrentUser() is a function that returns something. It's probably not doing what you think it is. Try stepping through it while you check the variables. If nothing pops up, maybe post the function code. Admin sounds like a level to me, not a user as in user name, so this isn't a case of it returning the wrong field from a table?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Always learning
Windows 10 Access 2016
Thank you Micron, I changed it to =GetUserName() and it's working now. :-)
Virtually Inert Person
Windows 7 32bit Access 2007
Wunderbar!
Posting Permissions
Reply With Quote