Combobox 'Item Not In List' problem
Competent Performer
Windows 7 64bit 
Access 2010 32bit
I'm sure it's been discussed countless times on here by many, but I cannot find a direct link to help me.
Combo Box has two columns, ID and FirstName, bound column is 1
When I type my name in the Combobox, it errors, saying not in the list. When I drop the list down and click my name with the mouse, everything works.
How do I get autocomplete to start working again?
thanks in anticipation
Competent Performer
Windows 7 64bit Access 2013 64bit
Added 'DISTINCT' after the "Select..." and it started working again. Sorry to disturb your day folks
combobox to populate item based on other combobox and save the record
Multiple Item Form search and combobox problem
Table field will not allow data entry says item not on list (Don't know of any list)
Posting Permissions
Reply With Quote