I have the following values in a table:
1 1 - Elmo
2 2 - Cookie Monster
I have these two fields on a form in access. When a user selects the ID from a combo box on the form, I would like for the textfield under the combo box to populate with the name. So, if I choose 1 from a combo box, then I would like for 'Elmo' to automatically populate in a textbox on the form below it. Is this possible?