In Access 2016, I have a combox with a list of Company Names and Company IDs. The Row Source of the combo box is:
SELECT COMPANY_NAME AS [Company Name], COMPANY_ID AS ID FROM tbl_COMPANY;
The bound column is COMPANY_ID, an integer. The COMPANY_NAME text is displayed in the combo box when a row is selected.
Since a company can have multiple aliases (company reports under different names), I have duplicated COMPANY_ID (bound column).
If a user selects a row for a case where its COMPANY_ID is also associated with one or multiple other rows, the text displayed in the combo box after it is selected is always the first COMPANY_NAME associated with the COMPANY_ID (bound column) found using the above SELECT (row source).
I was wondering if there is a way to have the exact COMPANY_NAME text populated in the combobox after it is selected.
As an example, If I have:
BMW, 1222
General Motors, 1223
General Motors Corporation, 1223
General Motors Inc., 1223
GM, 1223
Toyota, 1224
And I click on General Motors Inc, General Motors will be the text displayed in the combobox, but I would want General Motors Inc.