Curious if there is a way to get multiple columns to display in a combo box in the selected state. The columns work just fine when selecting something, but after the item has been chosen, it only displays the first column.
TIA!
Curious if there is a way to get multiple columns to display in a combo box in the selected state. The columns work just fine when selecting something, but after the item has been chosen, it only displays the first column.
TIA!
Technically no, though you can concatenate in the row source:
SELECT FirstName & " " & LastName AS FULLName...
and display the concatenated column. The other way is to have a separate textbox:
=ComboName.Column(x)
where x is the number of the desired column to display.
Thanks Pbaldy, option 2 will work very well for me.
Happy to help; I typically use option 2 myself.