I'm using a module that allows me to use the fOSUserName to grab the user computer login.
I have create a table for my reviewers called Reviewer_Table where I added all the computer login in a column and a second column for their full name.
In my main form I have a combo box to select a reviewer (by full name) from that Reviewer_Table. In the same combo box I set the default option to =fOSUserName() so when my reviewer log in they already have their information there. This value is recorded in a Quality_Table Under "Reviewer".
What I want to achieve:
1- Transform the login to their full name in the output table (and the form if possible) rather than their computer ID
2- Keep the ability to manualy change the reviewer name via the combo box
I did read something about dlookup or something but keep in mind that I started using Access back in December and I am not trained as a tech person