Hello,
What I want to do is when a person opens the form(frmRep) it will autopopulate my combobox(cmboRepresentative) with the first name of the person using it. I have made a table(tbl_Users) that has the persons Username and first name and other information on it. The first name field is called "First_Name". The row source of the of the combo box already has a query with all the reps names. I am trying to figure out the best way when the user logs on I can link the Environ("UserName") property to my table and assign the combo box with the first name.
Thank you