Forum Discussion
Stumped on auto populate staying in a combo box
This is embarrassing. I’ve been building databases since 1999 and now I’m stumped I have an MS Access database with a combo box that is used to select specific records. These records have two parti...
Hi,
There are occasional instances where AutoExpand doesn't work. This usually happens when the threshold of 100 entries is reached (at which point the list is automatically refreshed). Some versions of this problem have been fixed over time, but not all of them.
In these cases it often helps to expand the combo box. Try adding this line of VBA code in the combo box's GotFocus event:
Me!NameOfTheComboBox.Dropdown
Servus
Karl
****************
Access Forever, News, DevCon
Access-Entwickler-Konferenz AEK