I have placed an unbound combo box on a form.
This combo box has 4 columns, but only 3 of the columns are visible to the user. The "invisible" 4th column is the bound column.
After making a selection and moving onto the next control on the form, the combo box displays the previously "invisible" 4th column value (which happens to be a primary key id #).
I would prefer for the user to continue to see the 3 visible fields rather than the bound column value.
There must be a way to do this, but I'm spinning my wheels.
Any suggestions ?
This combo box has 4 columns, but only 3 of the columns are visible to the user. The "invisible" 4th column is the bound column.
After making a selection and moving onto the next control on the form, the combo box displays the previously "invisible" 4th column value (which happens to be a primary key id #).
I would prefer for the user to continue to see the 3 visible fields rather than the bound column value.
There must be a way to do this, but I'm spinning my wheels.
Any suggestions ?