Thank you @Logit,

Not quite. I'm loading the form's text boxes from the combobox (that I populated from a spreadsheet.)

This is a CRUD (Create Retrieve Update Delete) attempt. My combobox serves well as the target for the Retrieve, and the source for the Update (and Delete).

But not the Create.

If I can type in a name not in the combobox, which I believe is a feature that distinguishes it from a listbox, I can eliminate the TextBoxName control and set the cursor to the address text box. Which my user would find more intuitive.

But I am not understanding how to use the "textbox" combobox capability. That is, which event I should be using insted of ComboBoxName_Change()

Note: The code you thoughtfully supplied is what close to what I use to accomplish my Update (And my Add after I programmatically insert a row).