I have an Access form with several combo-boxes, all with "Limit To List" set to True. When I first login and enter something that is not in the list, I have some code triggered by "On Not in List" that asks me if I wish to add it, I select yes and it adds it correctly, with no extra prompts.
However, my form/application allows users to switch to other projects/back-ends. These back-ends are all very structurally similar but have different sets of data, dependant on the projects and need to remain completely separate. As soon as the applications re-links to the chosen back-end, the "On Not in List" event that worked originally, now has an issue. It comes up with the message, "The text you entered isn't in the list.", which is the problem. If I look at the new entry, it is in the drop-down list and if I select it from the list - it all works fine (but obviously, I shouldn't need to reselect it from the list).
Simply closing the form and re-opening it - doesn't work. I actually need to exit the Access application completely, re-open it - and once again, it works.
The combo-boxes are pretty much all text fields (not just numbers / date), and the combo-box fields themselves are bound to their respective fields in the main table. However, the "row source" of the combo-boxes is a separate table that is much smaller, grouped and indexed.