>When I programatically change the contents of combo1.value to a value not in its list, the control goes blank.
>When I change the style to 2 (dorpdown list) It takes the value. Why is this? What can I do to reverse this behavior?
>I want the combobox to accept values not included in the list and the dropdown list to reject them.
>
>PLEASE HELP!
>
>Thanks,
>
>Mike
You can try 2 things:
either reset DisplayValue property instead of Value
or (I guess it's more generic way) use ProgrammaticChange event to
1. Check that this is 'new' value.
2. Insert this value into RowSource.
3. Requery the combo.
4. Set value property again after requery.
Edward Pikman
Independent Consultant