I have a combobox with 2 colums (Col. Widths = 0", 2").
It's Controlsource is a Query with 1 table. The table has 2 text fields:
and the Query has both of the fields.(ID is the first field in both the Table and the Query)
I want to be able to type in the ID of the person in the Combobox and have the name show up in the field when I hit <Enter>, but not show the ID.
So, if the ID of Person1 is L, I want to type L and hit <Enter> and have "Person1" show up in the Combobox
I could tell you about what I've tried so far, but since it didn't work, I'll just suffice it to say I don't know how to do it.