Hi Steve,

>The problem I am having is when the user enters a value that is not in the list. I don't want to add the entered value to the list. I want to save the entered value in MyOtherTable.MyID.
>In other words, I can't have my cake and eat it too. I want it both ways.

Have two cakes, a Combo with the caption "Choose off a list", or a Textbox captioned "Or type one in." There, you don't worry about anything else, and don't forget to change your combo back to a drop-down list.