I like to use Comboboxes for that task. It already has "autocomplete" as a function of that box (nothing you need to do - it's enabled by default). You just need to set the recordsource of the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback