Access 2007 and combo box

[John Kreps]

Has anyone successfully created a form with combo boxes that
autocomplete in access 2007?! I'm pretty familiar with access, but
cannot get combos to autocomplete in 07. When i first add the combo,
it does autocomplete. HOWEVER, once I restart access, the combo
autocomplete stops completely.

Anyone else having this issue?? I'm using Visa and Access 2007. I've
tried using MDB and ACCDB formats with same results.

So frustrating....thinking of just going back to Access 2003.

 

[Allen Browne]

John, I'm not aware of this bug.

What's the RowSource for the combo? Could you try adding DISTINCT to the
query statement and see if it makes a difference?

How many records are in the RowSource table?
Local table (in this mdb/accdb) or attached?

Is the file in a trusted location, defined under:
Office Button | Access Options | Trust Center | Trust Center Settings

Does it make any difference if you create a shortcut to msaccess.exe, and
check the Run As Administrator box? Option 2 of this article:
http://allenbrowne.com/bug-17.html