Access Noob here. I'm making a form. I need the user to select a code from a list of existing codes as part of creating a new entry. There already exists a table that has a list of all the codes, and what they represent. The user is not going to remember what all the codes are, so I want to show them what the description of what each code is.
My solution right now is to have a text box that's connected to the new record field where the code would be entered, and a combo box connected to the fields in the table that define all the codes and their description. But this is kind of clunky and confusing. Is it possible to have a combo box that is populated by the list of codes and their description, and when the user selects and item from it, the value they picked gets written to the new record field that it needs to go to?