autocomplete not working

[psbsmms]

I have an unbound form and an unbound combo box that has a query as the row source. I can not get autocomplete to work. The 1st field in the query is text, indexed and unique. I know this has worked for me in the past, does the for have to be bound? I created a whole new form just incase it had some other problem but still no luck.

 

[MajP]

check the auto expand property. It should be "yes". Can you provide the sql and the number of returned columns?

 

[psbsmms]

Autoexpand is set to yes

SELECT tblProjects.Projectname, tblProjects.ProjectID FROM tblProjects ORDER BY tblProjects.Projectname;

 

[MajP]

What version of Access? Sounds like it could be a bug.

Try
SELECT DISTINCT tblProjects.Projectname, tblProjects.ProjectID FROM tblProjects ORDER BY tblProjects.Projectname;