* Program...........: CMBKEYACCTMGR.INIT
* Author............: Jim Weil
* Project...........: CRMS
* Created...........: 05/27/03 15:13:50
* Copyright.........: (c) New York Blood Bank, 2003
*) Description.......:
* Calling Samples...:
* Parameter List....:
* Major change list.:
Local lcSQL
*-----------------------------------------------------------------
*-- JMW - May 27, 2003
*-- Get KeyAcctMgr data by region
*-----------------------------------------------------------------
lcSQL = ;
"Select mgrname, id " + ;
"from keyaccmgr " + ;
"where geo_area = m.us_geo_area " +;
"into cursor c_keyaccmgr " + ;
"order by mgrname"
*-----------------------------------------------------------------
*-- JMW - May 27, 2003
*-- Set the combobox attributes
*-----------------------------------------------------------------
With this
.rowsourcetype = 3 && SQL Statement
.rowsource = lcSQL
.BoundColumn = 2
.BoundTo = .T.
.ControlSource = "Sponsor.Keyaccmgrid"
.ColumnCount = 2
.ColumnLines = .f.
.ColumnWidths = "200,0"
.Requery()
Endwith
Return
>James,
>
>Can you show us the overridden properties and code attached to the cbo?
>
>>Thanks for responding Dave. I have tried calling both methods, but nothing seems to work. It displays properly if the boundto is set to .f., but then the incorrect value is saved (the row number, not the data value). This is getting frustrating!