Multiple Column Combo Box

[Guest]

I have a 2 column combo box (column 1 contains 1-alpha character and column 2
contains a description of column 1 code) that is created by a table and I
have column 1 as my search information I will be using in a query but I would
like to have column 2 listed as a text box just for informational purpose.
Can anyone help me out.

Thanks!!!!

 

[Guest]

Hi, Zee.

Set the ControlSource of the textbox to:

=Me!YourComboBox.Column(1)

Hope that helps.
Sprinks

 

[Guest]

in the control source of the text box, put the following
=ComboBox.Column(1)

 

[Guest]

Thanks, that was exactly what I needed.

Hi, Zee.

Set the ControlSource of the textbox to:

=Me!YourComboBox.Column(1)

Hope that helps.
Sprinks

 

[Guest]

Thanks!!!

in the control source of the text box, put the following
=ComboBox.Column(1)