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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results