An age old question. How can we use a combo box to add new values to its list, “on-the-fly”?
This question has been answered thousands of times, and people keep asking it. Well, I am adding my voice to the side of the answers crowd in the hopes that at least 1 person will not have to ask.
To read my version of the answer, visit Not-in-List.
p.s. This one comes with a sample database!
I was reminded today why I avoid activeX components. Someone was having trouble installing a small Access database on to their computer. (I did NOT create the database) We quickly traced the problem to an older version of an OCX file on their computer. After 3 attempts to unregister/re-install/re-register the ocx file we finally got it working. Fortunately, this computer was walking distance from my desk. What if it had been in an office in another city?
What was the offending activeX control? A calendar. If you have not already done so, see my series about a calendar control that is pure Access (no activeX) starting at this web page.
