Take a look at MSKB#
Q140652 HOWTO: Capture Input in a Combo Box and file#9596 Dropdown Combo.
>I'm using a Combobox where I used to have a Textbox. It is SQL to a cursor, has a view field as ControlSource and is Bound. When I type in new information that doesn't already exists in the results of the SQL it does not save it to the view. IOW, if the SQL returned as list:
>
>A
>B
>C
>
>And I type in B where the old value was an A, or select it from the drop list, it will work. If I type in D for the new value, it will not save.
>
>Any ideas? Thanks!
>
>Regards, Renoir
--sb--