Combo Box Display

[dmyoungsal]

I have a combo box on my form that allows to user to select the piece of equipment being selected. Once selected, the displayed information is that of the first column shown in the pull down.

Is there a way to have it show both columns (Category and description) after the selection is made?

I have been able to do this by using a textbox "=[cboCategory1].[column](2)", but this text box takes up extra space on the my already limited available screen.

 

[pbaldy]

One option is including an additional column in the combo's row source query that concatenates the fields together, and make that the displayed field.

 

[dmyoungsal]

what is the concatenate code?

My fields are: Category/Class and CategoryDesc

 

[pbaldy]

Like

DisplayField: [Category/Class] & " " & CategoryDesc

 

[dmyoungsal]

I have made the query and concatenated the two fields I want to display. when I "run" the query, the fields display as I want, but when I close the query, re-open the form and click on the combo box, there is no data.

?????

 

[pbaldy]

The combo's properties would need to be adjusted to account for the extra column (likely the column count and column widths properties).

 

[dmyoungsal]

The combo's properties would need to be adjusted to account for the extra column (likely the column count and column widths properties).

Once again you came up with the answer!

I was looking at other posts and they referred to removing the separate fields (that were ultimately concatenated). When I did this it caused the pull-down to be blank.

Thank you again!

 

[pbaldy]

Happy to help!