>>I have a problem with a ComboBox. I have the folowing properties set, but when the user adds an entry not listed in the RowSource, the data is not saved. What to I have to do so the user can add a new entry and the entry is saved to the table (I don't need it added to the RowSource).
>>
>>ControlSource = helthins_param_view.user_comment
>>RowSource = Cancellation,Death,LOA,Please Refund,Prepayment,Retirement,Return from LOA,Termination
>>RowSourceType = 1
>>Style = 0
>>
>>
>>Jeff
>
>Two things have to be done:
>1. Unbound control, i.e. ControlSource=""
>2. in Combo.LostFocus event:
>If this.displayvalue!=this.value
> Select helthins_param_view
> Replace helthins_param_view.user_comment With This.DisplayValue
>Endif
Sorry, one more add-on:
>2. in Combo.LostFocus event:
Select helthins_param_view
Replace helthins_param_view.user_comment With This.DisplayValue
'IF' is extra, because you have to store any value (from or outside the list).
Edward Pikman
Independent Consultant