Storing User Information Throughout Application

[MrAustin]

Hey all,

If I have a user login at the beginning of my access program, how can I later access their username, password, security level, etc? I would have thought I just stored it in a public variable at login time, but this doesn't seem to work. Any help?

Thanks!

 

[pbaldy]

Access Security or your own? A public variable should work. I usually use a hidden textbox on a form that stays open, since it requires no additional code to use it in a query.

 

[KenHigg]

You may be able to get what you need with CurrentUser().

???
kh