Article ID: 134466
Article Last Modified on 2/12/2007
APPLIES TO
- Microsoft Visual FoxPro 7.0 Professional Edition
- Microsoft Visual FoxPro 8.0 Professional Edition
- Microsoft Visual FoxPro 9.0 Professional Edition
This article was previously published under Q134466
SUMMARY
This article describes how to populate a combobox object with multiple columns. This is done from a cursor that is created by using a SELECT-SQL statement.
MORE INFORMATION
For a DropDown ComboBox to display an initial value and multiple columns from a cursor created by an SELECT-SQL statement, Microsoft recommends that you use the following property values and methods:
Example ComboBox Properties:
BoundColumn = 1
ColumnCount = 3
ColumnWidths = 0,100,100
RowSource = SELECT city+' '+region as MyField,city,region ;
FROM Customer ;
where !empty(region) ;
into cursor MyCursor
RowSourceType = 3
Example: ComboBox GotFocus event
This.Value = MyCursor.MyField
Additional query words: VFoxWin
Keywords: KB134466
