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"
If it's not broken, fix it until it is.
My Blog