DROPDOWN TO DISPLAY BOTH FIELDS IN FORM

[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?

 

[fredg]

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?

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.