I have a datacombo whose data source is adodc (access 2000). The two items in the table are employee name and employee number with the key being the employee name. When I open the form and the data combo loads it lists the employee name in emp number order.

I need the bound text to be the employee number, but, I want the displayed text to be the employee name so that a user can key the name and scroll down.

What controls how it displays.

Thanks in advance.