>>>>:) 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

I already had a work around. Please see reply from the Jim and my reply to him for detail.

Thank you very much for your effort.

Bye
Jayesh