Depending on the version of Access you have, this method might be different. This solution can work for all Microsoft Access versions.

OK here is the situation. I have a users database for this application we are using. within it each user has a unique ID for 2 different programs. The program that uses these ID's grabs those values ...