Is there a way to grab an environment variable to use in a query and add to a table? Company stores users ID in the env. I tried using the CurrentUser() but that returns Admin for everyone.

Basically I have a form that is used to provide query inputs. Was fine until muliples started using it. Now I need to provide a user id column to the input form and to the queries so that I get the correct person's request.

Clear as mud... :-)

Any help would be appreciated.

Thanks
Joe

And it works. Grabbed the Environ("Username"), put it on the form and then told the query to use the value on the form. Tomorrow I'll move it into production...

Thanks Scott for the help.

Joe