Combobox could be multi-column. Set Properties:



RowSource: SELECT FISNumber, fieldname FROM tablename;
ColumnCount: 2
ColumnWidths: 0";2.0"
BoundColumn: 1
LimitToList: Yes

FISNumber column would be hidden. User enters text but the combobox value is numeric FISNumber. The search code would exclude apostrophes:

.FindFirst "FISNumber=" & Me.cbxFISNumber

Otherwise, set combobox RowSource to return only the descriptive field and use search code that compares to descriptive text field.

Might want to explore the combobox NotInList event.