No, you're using RowSourceType = 6 (fields).
>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"
If it's not broken, fix it until it is.
My Blog