DROPDOWN TO DISPLAY BOTH FIELDS IN FORM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form that contains a dropdown that displays Customer # and
Customer Name. Once I select one the Customer # is the only item that
displays. Is it possible to have the dropdown display both the # and Name?
 
I have created a form that contains a dropdown that displays Customer # and
Customer Name. Once I select one the Customer # is the only item that
displays. Is it possible to have the dropdown display both the # and Name?
Click to expand...

No. After you have selected an item from the combo box, the combo box
will display just the first column whose width is greater than 0".

Add an unbound control to the form. Set it's control source to:
=[ComboName].Column(1)
Combo boxes are zero based, so Column(1) is the second column.
 
Back
Top