Hiten,

Check this message for the answer: Forum: Visual FoxPro Category: Forms & Form designer Title: Re: Adding data to a bound combo box Thread #488389 Message #488428

>Hello People.
>
>Once again I have a problem.
>
>I have a combobox on my form which is bound to a field in a table.
>
>The RowSourceType property is set to 3 - Sql Statement
>The RowSource property is set to
>"Select Distinct Remarks from TransactionTable into cursor lvRemarks"
>The Style property is set to 0 - Dropdown Combo
>The ControlSource property is set to TransactionTable.Remarks
>
>Now the problem is that when instead of selecting a value from the list I type in a new value and save the record, a Blank value is saved instead of the new typed value ..
>
>Any Idea why this is and is there a solution to it ?
>
>Thanx