Working with long lookup lists

[Doctorswamp]

Have simple continuous form to create a pick list. One combo field looks up products from a list of about 5000 items.

Even though the combo homes in as letters are typed there is still a lot of typing needed to identify the target product. This is because many products have the same 10 to 15 characters to start, then have different endings.

It would be great if in adding a new item the combo remembered what was typed in the previous entry, as the picklist is built alphabetically.

Any ideas

 

[RuralGuy]

Maybe you will find this link useful. Combos with Tens of Thousands of Records