ACCESS Combo Wizard Receives EmplNAME ok but Stores ID, instead of Name

I want EmplNAME to be stored in the Table, not ID.
I used the "Combo" wizard, and selected just EmplNAME.  When asked what field I wanted to store in my table, I selected EmplNAME.
(Yes. EmplID is the primary key.)
Users are successfully selecting the appropriate EmplNAME from the drop down box.
However, it is the EmplID that is being stored in the Table.
Is there a way that I can get the system to store the Name in the table instead of the ID#?
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
change the value of Bound Column property of the combo box..

if your row source is

select EMPID,EmplName from tableName

set the Bound Column to 2

or you can simply use the row source

select EmplName from tableName

and set the bound column to 1
willjxAuthor Commented:
"set the Bound Column to 2"  worked great inasmuch as I had to do it for 2 fields.
Thanks a lot.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.