OK. I've just checked what I did in a very similar situation. I have an extra column to take the description field.
In the interactivechange() of the combo I have:
With This.Parent.Parent.Column3.Text1
.Value = This.List( This.ListIndex, 2)
.Refresh()
EndWith
Can't remember the reasons. I did want to show both the code AND the description in the grid. Maybe I came up against the same problem
>Terry
>
>>Does it help if you set BoundTo = .T. ?
>
>No the result is the same
>
>Luigi
>
>>Terry
>
>>Hi at all,
>>
>>I have the following situation
>>
>>Table name.dbf
>>Code c(4)
>>Description c(20)
>>
>>Table data.dbf
>>xxxx c(2)
>>yyyy c(2)
>>Code c(4)
>>
>>
>>I have a grid for table data.dbf and in the column of Code I have insert a combo with following settings:
>>
>>BoundColumn = 2
>>ColumnCount = 2
>>ColumnWidths = 75,0
>>ControlSource = table.code
>>RowSourceType = 6-Fields
>>RowSource = name.descritpion,code
>>Style = 2 - Dropdown List
>>
>>It works fine if I set the Sparse setting of column = .f. but I want to have the combo visible only if the customer click in row, this works if I set the sparse setting to .t. but the value displayed in column is obviusly the code and not the descriprtion is there any solution or idea for this situation.
>>
>>Thank you in dvance for any help.
>>
>>regards
>>Luigi
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.