I have a small form with one combo box that I can't seem to get working. the record source is a query with the first 2 fields a contactID and the next the person's name. I've set up the combo box to key off the contactID and show field2, the name for a person to select. when I open the form, the combo box immediately shows the first person in the list and won't let me select a different persons name.
I've done combo boxes before, is there something different with Access 2013 or am I missing something really obvious?