If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 and combo box
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. |
#2
|
|||
|
|||
Access 2007 and combo box
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 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "John Kreps" wrote in message ups.com... 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. |
Thread Tools | |
Display Modes | |
|
|