Huh? That
is a cursor -- and I tried an array, that did not work either.
>I don't know why, but I dislike fields for combo's RowSource. I always use cursor or array.
>
>>I'm having a frustrating problem with what should be a simple use of a combobox.
>>
>>The problem is that the combobox does not show the currently selected value (displayvalue) properly -- either when it first comes up (where its controlsource is already assigned a value that matches an entry in its rowsource), or when I click on an item in the dropdown.
>>
>>The crsr_Employees table is simple -- field 'name' is character, field 'empidnum' is numeric.
>>
>>(Note that even though the item clicked on does not show up correctly in the combobox, the correct value is saved correctly in the controlsource.)
>>
>>BTW -- there is NO method or event code for this combobox -- plain old vanilla stuff.
>>
>>Help!
>>
>>
ADD OBJECT updatetable1.cntupd.cntedit.combo1 AS combobox WITH ;
>> FontSize = 10, ;
>> BoundColumn = 2, ;
>> ColumnCount = 2, ;
>> ColumnWidths = "200,0", ;
>> RowSourceType = 6, ;
>> RowSource = "crsr_Employees.name, empidnum", ;
>> ControlSource = "Thisform.oBusObj.oData.empidnum", ;
>> Height = 24, ;
>> Left = 536, ;
>> TabIndex = 13, ;
>> Top = 38, ;
>> Width = 168, ;
>> BoundTo = .T., ;
>> Name = "Combo1"
Jim Nelson
Newbury Park, CA