>I have a ComboBox on my form whose ControlSource is a field in my table. The RowSource is an SQL statement (assigned in the Init), but I want my user to be able to choose an item from the list OR enter a value of their own (not necessarily on the list). The box comes up with the current value of the field but if I type in a value NOT in the list, it blanks out. (The Style is set to 0-Dropdown Combo). Is this how it's supposed to work?
>
>Thanks
>Elyse
1. Clean Combo.ControlSource property.
2. Combo.DisplayValue=Table.Field && set it in form 'refreshing' method.
3. Use DisplayValue property to replace/insert into field when you save the record.
Edward Pikman
Independent Consultant