>>>I have a table that contains two fields (let's use state code
>>>and state description). What setting do I need to have to show
>>>both the state code then the state description in a combobox
>>>when it is not selected (user has not clicked on it yet)?
>>>
>>>I'd also like to see the best way to use a rowsource for this
>>>excercise since there are 10 options here...
>>
>>Combo.RowsourceType=6
>>Combo.Rowsource="Mytable.State,Description"
>>Combo.ColumnCount=2
>>What do you want to see in text portion of the combo? Both fields together or just State?
>
>Ed, thanks for the reply. I have two fields, state_code and state_desc
>in that order. When I click on the combo box and it drops down I see
>both fields. However, when it is not clicked, I only see the state_code.
>Is there a way to see both fields when not selected?
You can do it by modifying rowsource, adding one more column there as concatenation of two fields. You may run Select to get three fields into cursor and use these cursor fields as rowsource. Concatenated field should be first one and Combo.ColumnCount=3, Combo.ColumnWidth=0.
Edward Pikman
Independent Consultant