ms access - How to make a textbox display a different field than it controls? -

so @ top of page have combo box select current employee. form chiefly made of checklist items completed. set macro, when checkbox next item clicked, populate 'completedby' field whatever value in combo box @ top of page. way can select name once, , check off items have completed, , respective name recorded each item have done.

however want display employees name, manipulate 'employeeid' field.

so how make textbox display value, manipulate different value in table>? or if impossible, other paradigm use accomplish this?

this tutorial on how bind combo box primary key display description field: works on old version of microsoft access. don't know if newer versions of microsoft access use different , simpler approach (i.e.: .displaymember , .valuemember properties of combobox in vb.net).