>I have a drop-down listbox in Visual Class Form; code
>is shown below. See embedded comments for clarifications.
>
>QUESTION is below code snippets.
>
>I have code in my Visual Class Form init() routine:
>
>form.init()
>...
>...
>SELECT TRIM(DD_ships.sh_name)+" "+TRIM(DD_ships.sh_type)+"-"+TRIM(DD_ships.sh_hno) AS ship, ;
> DD_sdilist.sl_shipid,TRIM(DD_ships.sh_type),val(DD_ships.sh_hno), ;
> DD_sdilist.sl_idxtype ;
> FROM DD!DD_sdilist inner JOIN DD!DD_ships ON ;
> DD_sdilist.sl_shipid=DD_ships.sh_shipid ;
> &l_cWhere ;
> ORDER BY 3,4 INTO CURSOR curSDIlist
>...
>
>*// cboShip is drop-down listbox
>*// RowSourceType is 6 - Fields
>
>THISFORM.cboShip.ROWSOURCE="curSDIlist.ship,sl_shipid"
>...
>...
>
>
>* In cboShip.InteractiveChange() method code is:
>
>WITH THISFORM
>...
>...
>...
> SELECT DISTINCT dd_sdidata.si_index FROM dd_sdidata ;
> WHERE dd_sdidata.si_shipid=VAL(THIS.VALUE) INTO CURSOR
> curIndexList
>...
>...
>ENDWITH
>
>>>>>>>>>>>
>
>My question is how does the InteractiveChange() method for drop-down list pick the 2nd column (Field) from Rowsource for cboShip Value. I've confirmed this fact through debugging.
>
>FZ (Boston MA)


Is your BoundColumn = 2?