I have a comboBox to add Location IDnumber into a tables, the comboBox displays 5 fields and has col 1 as bound field. When I type a number it goes to that record and adds ID to the table and listBox in the form. I have many locations (+1000) and not easy to find the correct IDnumber. I would like to select either IDnumber (autonumber) or Col 2 (string) as the autoExpand data in the comboBox. Is this possible? ComboBox not the best practice with this amount of records.
Thanks!