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

Bye
Jayesh