>>>I have a combo that has a 2 column array as it's rowsource. The first column of the array is a description of column 2. I want the description do be displayed in the combo and I want column 2 to be bound to the control source.
>>>This works in 6.0
>>>
>>>Any Suggestions?
>>>Thanks
>>
>>You may use Combo.Boundcolumn=2 to bind Combo.Value to the second column. If it's integer, you cannot use bound combo (i.e. this case controlsource should be empty).
>
>
>The following code works in 6.0, fails in 3.0b
>this is the init for the combo.....
>When 1st is selected, "A" is stored in pprollm.csign.
>*----------------------------------------------------*
>* Build array for rollup definition
>*----------------------------------------------------*
>DIMENSION thisform.arowtypes(5,2)
>thisform.arowtypes(1,1) = "Add To Rolling Balance"
>thisform.arowtypes(1,2) = "+"
>thisform.arowtypes(2,1) = "Subtract From Rolling Balance"
>thisform.arowtypes(2,2) = "-"
>tthisformis.arowtypes(3,1) = "Do Not Include Into Rolling Balance"
>thisform.arowtypes(3,2) = "O"
>thisform.arowtypes(4,1) = "Total Line"
>thisform.arowtypes(4,2) = "T"
>thisform.arowtypes(5,1) = "Blank Line"
>thisform.arowtypes(5,2) = "B"
>
>this.rowsource = "thisform.arowtypes"
>this.rowsourcetype = 5
>this.boundcolumn = 2
>this.controlsource = "pprollm.csign"
>this.requery()
and what fails in VFP3? BTW, I always wonder why people use arrays as combo.rowsource. Anyway, you do it manually, so why not to fill the combo with about the same amount of code (actually less) using AddListItem? The difference is that this (non-rowsource) way is absolutely clear which is counted if some problems will require debugging. Another good way to debug combo problems is to clean combo.controlsource (i.e. make it unbound) and check correctness of Combo.Value property.
Edward Pikman
Independent Consultant