Display two columns in combo box

[Jon Melone]

Hi,
I have a combo box on a form that allows users to select from a list of values based on a query. In the dropdown, the two columns from the query are visible (ID, Description). But once a selection is made, only the ID is displayed in the field. How do I get the Description to display along with the ID?

Thanks in advance for any assistance,
Jon

 

[boblarson]

Hi,
I have a combo box on a form that allows users to select from a list of values based on a query. In the dropdown, the two columns from the query are visible (ID, Description). But once a selection is made, only the ID is displayed in the field. How do I get the Description to display along with the ID?

Thanks in advance for any assistance,
Jon

Combo boxes only show the first visible column after selection. So, if you want the ID to show up with the description, then you will need to create a concatenated field in your combo's row source and make it the only visible column. You would still have the ID as the first column and then the second, instead of description, you would have something like:

IDDesc:[ID] & " - " & [Description]

and in SQL View it would be something like

SELECT ID, [ID] & " - " & [Description] As IDDesc
FROM TableNameHere

And then you set the combo's column count to 2 (as I think you already have it) and the column widths to

0";2"

or however long you need for the last one but the first column would stay at zero (0) so it wouldn't show.

 

[Jon Melone]

Success!
Thank you for your prompt response.

Jon