Drop Down Box Values

[catbeasy]

I have a drop down box in a form that reads 2 columns from a table. One of the columns data populates into a text box where, later it will be stored in a table.

However, this value is a code value. The description value column shows in the drop down box next to the code. The user has requested that this description value show up as well. In validating their data (before it is saved), they don't want to read the code value, they want to read the description (as the code value doesn't mean anything to them)..

I'd like to read the description column data into another text box. Does anyone have a suggestion on how to do this?

 

[pbaldy]

Put a textbox next to the combo with a control source of:

=ComboBoxName.Column(1)

 

[catbeasy]

Put a textbox next to the combo with a control source of:

=ComboBoxName.Column(1)

Thanks, that works!