View Full Version : List Box Columns


kmarks
01-31-2000, 09:23 AM
I want to display two columns in a textbox that is filled in by a list box. I.e. - I want the same thing that is in the dropped down list on the listbox to appear in the text box. How can I do this?

cbasulto
01-31-2000, 11:23 AM
make the control source of your text box =ListBox1.columns(0)

kmarks
01-31-2000, 02:46 PM
I've tried that and it didn't work. My listbox name is "Reason", so in the control source (in properties) I have
=reason.columns(0)
What am I doing wrong?

R. Hicks
02-01-2000, 04:33 PM
If I understand you, you want to place the values of two of the columns from the ListBox to one txtbox. If the is correct then.

The in the control source of your text box:
= reason.column(0) & " " & reason.column(1)

Notice that it's "column" not "columns"

Maybe this will help
RDH


[This message has been edited by R. Hicks (edited 02-01-2000).]