Mike Yearwood
Toronto, Ontario, Canada
I'd point to grocery.fruit_id.
>Hi Mike,
>
>Yes, my cbmo_fruit is displaying the right data. In my grid column, do I use the controlsource to point to fruit.fruit_desc? Right now, I have the column pointing to grocery.fruit_id instead.
>
>Thanks
>
>
>>When you place your cursor in the field, does it show the correct fruit? If >so, I believe you have the combo's right, but you need to change the Sparse >setting of the column containing the combo.
>
>>HTH
>
>>Hi All,
>>
>>I have a form which contains a grid and some combo box fields. I populate the two columns combo box in the init() of the form like the following...
>>
>>select fruit
>>for i = 1 to reccount()
>>With this.cmbo_fruit
>>.addlistitem(fruit_name,i,1)
>>.addlistitem(alltrim(str(fruit_id)),i,2)
>>endwith
>>endfor
>>
>>I stored the fruit_id into the table where I am currently using as the recordsource in the grid. Instead of displaying the name of the fruit like apple, lemon, etc..., I ended up displaying the fruit_id in the grid. The column's controlsource is assign to fruit_id. How can I fix this problem? TIA
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only