Steve,
>I believe the reason I can't ControlSource to the table is because the user may either pick something from the dropdown list or enter a number into the combobox. And I don't want to add the number they entered to the dropdown list, only save it in a table.
This is the way a normal cbo works. I've always used cbos with style=DropDown List instead of DropDown Combo. Why not give it a try and see if it works for you. Normally the question here about dropdowm combo is how to get the user entered value to appear in the droplist.