List Box Bound Column

[thatlem]

Does anyone know how I can write a code to define a variable to use a different bound column in a listbox?

I have a listbox which is bound to pull the code in one report, but I need it to pull the description in another report so I can concatenate two elements. I want to use the same listbox and not create a separate one with a different bound column.

I had used: stDocName = Me.FacilityListBox.boundcolumn = 2
but that did not work.

Suggestions

 

[John Big Booty]

Why are you unable to construct a query that collects the data you want from the List Boxes bound column. If the data you are looking for is related to information in another column on the same row as the list box, that data must surely be related also to the List Boxes bound column as well

 

[pbaldy]

Is this what you're after?

stDocName = Me.FacilityListBox.Column(1)

The column property is zero based, so 1 is the second column.

 

[thatlem]

PBaldy -
That's just what I needed...

Thanks.

 

[pbaldy]

No problem. John's thought is a good one; getting the info through query joins would be more efficient.

 

[John Big Booty]

I think I misunderstood what the end goal was. If it was, as appears, just to represent that info in a text box on the same form, then forget what I said