i have a combo box that lists employees and their id numbers
as it is now, i have the list sorted by employee with the employee as the bound column. if the user starts typing in the name, it will autofill the name from the list.
is there any way to switch the autofill if the user starts typing in the numbers of the employee's id number? for example, typing "S" might bring up "Smith, John" or typing "4" might bring up the id number "4283" .
thanks in advance for all help