Who Logged In

[CementCarver]

I have an employee table which is read when one of the three users logs into the database. I don't want the persons name who's logged onto the pc. But when I try to set the variable to be = CurrentUser(), I get the user named "Admin", who is not even in the employee table.

How do I get the name of the person who's logged into the database from the employee table?



CementCarver

[pbaldy]

How do they log in? CurrentUser() only works with Access built-in security. If you've created your own, you need to save the value yourself, either in a form control, global variable or a table.

[CementCarver]

Yes, I've created my own login screen. How does one populate a global variable to be used later on?

CC

[pbaldy]

VariableName = YourValue

[CementCarver]

Thanks pbaldy....CC

[pbaldy]

Happy to help.