Table lookup, sort of

[avarusbrightfyre]

Ok, so I'm trying to mimic the whole user level security thing because our database needs to assign work to be done to certain levels of leadership. I have a table with usernames and security levels assigned to them, and I'm using the "environ(username) function to grab the username automatically so my computer illiterate co-workers don't have to log in. What I need is a way to compare the environ username to my table, figure out what the security level for the current user is, based on the table, and use that sec level to allow or disallow access to certain information and buttons.

Is this possible? Right now I'm using a text box with form loading code that sticks the environ username into the text box. Usernames for each user will always be the same no matter what machine they log into. I just can't figure out how to use that to get the sec level I need

[pbaldy]

A DLookup() would be one way. Given that you'll need it throughout the application, I'd probably grab it after you get the user name and store it in another textbox. More on syntax:

DLookup Usage Samples