Just updated to a new Windows 11 PC and ported in my Access 2016 apps.
One app has a form with 2 combo boxes each linked to their own table of values.
On WIndows 10 both these boxes would autocomplete so if you typed "ab" the box would find the first entry in the table starting with these letters and suggest the first value it found "Aberdeen" (say)
One Windows 11 the first box behaved the same way - but the second never suggested anything (not quite true - but read on)
It appears that if there are less than~100 entries in the table then Auto complete works, but if there are more than 100 entries then it doesn't .
Really annoying and was almost on the point of going back to Windows 10 when I stumbled on a perfect solution.
Code:
Private Sub cboLocation_Enter()
cboLocation.Dropdown
End Sub
and as soon as you tab or click on the box, the list drops down and Autocomplete works :-)
Hope this helps