User-level login & global variable

[CoddFish]

I am wondering if there is something like a global or session variable within Access that can be updated upon login (that is, the user-level login provided by MS Access' Workgroup Administrator). This way, I will be able to more precisely control various user features based upon who is logged in.

 

[pbaldy]

There are global variables available, but if you're using Access security, you can get the user with the CurrentUser() function. You don't need to store it.

 

[CoddFish]

Thanks Paul!

That's awesome -- thanks Paul! You just made my life much easier!