Combo Columns

[Guest]

I've created a combo box on a form in Access using 2 columns. The first
column is hidden so the second column is the only one displayed in the combo
box. When I then use that combo as the source in a separate text box the
answered returned is the first column. Any idea how I get the second column
information instead?

 

[Guest]

Set the separate text box control source to
=[ComboBoxName].Column(1)