Naomi -
First of all, thanks --
Second -- it was not at all clear to me what you were suggesting I change -- that is why I was asking you to clearly identify what you were suggesting as an alternative.
>I'm not saying it's wrong, it's just my preference to use cursor (alias) for the type. (type 2)
>
>>So, instead of just telling me what I'm doing wrong, how about telling me what I should be doing -- I don't see a RowSourceType for Cursor.
>>
>>
>>>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"
Jim Nelson
Newbury Park, CA