>I have a listBox with two columns and I want to run through this listBox and display the values of both columns. The code i wrote will only display one value, the column that is bound.
>
>Thanks
Randy, are we supposed to guess what your code is like so that we can give you the solution?
By "run through" do you mean "as you select each row in the list" or "You loop through the list"?
Whichever, you can use:
With Thisform.lstMyListBox
lcDispVal1 = .List( lnSelRow, 1)
lcDispVal2 = .List( lnSelRow, 2)
EndWith
I don't see how the bound prop would come into it.
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.