Here is my problem.
I have a form in my MS Access DB that shows a current part number and its associated details. I currently have the part number in a combobox, when you select the part that you want the details are shown in the fields below.
What I would like to have is that I can type a part number (or a portion of it, with autocomplete) and hit enter, and have the part details shown below. Currently when I make the combobox editable, such that I can type text into it, I instead end up changing the part number for the record currently shown. Otherwise my combobox works as expected, you can click the down arrow, select a part number, and the details are displayed correctly.