>>>:) RowSourceType = 6 (Fields)
>>>:) RowSource = v_City.cDesc,cId
>>>:) ControlSource = v_customer.cCityId (Character Field)
>>>
>>
>>Jayesh,
>>
>>I think I see the problem. I have never been successful at getting any column but 1 to display in a closed combobox. Your description is the same as my observations. Does the combo show the description after you leave it?
>>
>>The way I have handled this in my forms is to use a textbox in combination with a combobox, the textbox show the description while the combo is used to show the city ID and to look up a city. I make the textbox readonly so the suer won't accidentally edit the value in there.
>
>Hi Jim,
>
> My Combo shows value when it gets the FOCUS. Either by TABBING or by Calling cbo.SETFOCUS()
The combo will only show one field when it doesn't have FOCUS. To get around this, when needed, I put a disabled textbox next to the combo, and bind the text box to the table.field I want displayed. Then, in the interactive change of the combo I refresh the textbox...it works great and looks pretty cool :0