combox.select()

[sncheong]

my combobox is working fine. after clicking it, i can store the respective listindex. what i want to know is the listindex preceding the selected listindex. how do i do that?
the rowsource of the combobox is select accn_id, accn_name from ledger1 without grouping and its rowsourcetype is 3. please help. ta

 

[Alias]

incomplete info. pls express further. how do ur combobox store listindex? What do u mean by preceeding the selected listindex?

 

[sncheong]

say the combobox shows accn_id and accn_name eg
123 stationery
444 wages
463 entertainment
933 salary

and i clicked 444 entertainment.
how can i simultaneously capture 444 wages in another variable?

 

[DSummZZZ]

To capture these into an array, you could declare a form array or a public one, then use the InteractiveChange for the combo box and do something like:

SELECT accn_id, accn_name ;
FROM ledger1 ;
INTO ARRAY MyArray

Then just use the array like any other.
Dave S.