List Box Columns (1 Viewer)

[kmarks]

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]

make the control source of your text box =ListBox1.columns(0)

 

[kmarks]

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]

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).]