How do I return a parsed value in an access form textbox based off of the value that the user selects from another combo box on the same form
Posted on 2011-03-20
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?