By default, the combo box will select the first item in the list that matches the user input, but it will continue to display all the other items as well. Our technique displays only matching items.

Lookup fields and combo boxes are two useful tools for data entry in Access. They allow you to create forms that display a list of predefined values for a field, instead of typing them manually.