In a combobox, the leftmost column is the bound column, in my case, and it is the ID field (Say the customer ID), and it is also hidden. I found out that, by default, the displayed text in the combo box space, after a selection is made, is column 1, the column to the right of the bound column. How do I change that? :et's say I want to display column 3 or 4 after a user makes a selection?
I meant in VBA I want a code like AfterUpdate:
Me.cboCustomers = me.cboCusterms.column(3)
but this is wrong!
How do I do it. I researched and could not find a solution.