Apparently, there was a problem with the first post.
What I need is a combo box that is a combination of
"I want the combo box to look up values in a table or query"
"I will type in the values that I want"
For example, the combo box called "Pick a color" should get its values from the table PLUS contain "No Color" and "Fuchsia", just in case the first person who wants to use this color doesn't know how to spell it. Just a dumb example.