Enhance Combo Box

[Guest]

Hello:

When I place a FIND student box on a form, the user can type in the first
few letters of the student's name and go right to that individual. However, I
created a Combo Box to lookup the student by Lastname, Firstname, and MI, but
enter the StudentID value in the field. That works, however, scrolling
through 4,500 names is a slow and tortuous process.

There must be some Access trick which enables a user to type in the first
few letters of the last name, go right to that name, but still enter the
StudentID instead of the name.

Thanks,
Robert

 

[Guest]

Yes you can. It is based on your bound column and display columns.

Row Source Type -- Table/Query
Row Source -- SELECT EM_List.ID, EM_List.PERSONNEL_NO, EM_List.LAST_NAME,
EM_List.FIRST_NAME, EM_List.MIDDLE_NAME FROM EM_List;
Column Count -- 5
Column Heads -- No
Column Widths -- 0";1";1";1";1"
Bound Column -- 1
The ID is not displayed bu is the bound field.