>I usually populate a listbox with a cursor from a select statement, but now have to use an array. Moving up and down in the listbox moves the pointer in the cursor giving me the ability to find the other columns associated with the record or row I am on. With a multidimensional array, how do I easily accomplish this same task? I am displaying desciptions but need the ID in the array. (Some of the desciptions may be the same.)
>
>Thanks for any help
>Greg Cummines
You must use the listindex property of the list to get the row number of your array. ex:
MyID = MyArray[Thisform.List1.ListIndex,2]
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca