Combobox allow entry not in the row source

I have a combobox on a form.  The combobox allows the user to select from a list of options.  But is there a way to allow the user to enter a string of characters in the combobox that are not in the list as a one-time entry only?  It other words I want it to be allowed but not entered in the combobox rowsource table.
Who is Participating?
Dale FyeConnect With a Mentor Commented:
If you set the LimitToList property of the combo box to false, you can do this, but this assumes that the combo box is displaying the same value you are storing, not storing an ID that is associated with a value.
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
There are two case of this...all under the Event NotInList
Either you enter a text and you insert it to the list of records of your combobox rowsource
Either you use this specific text to perform the filtering without reusing it...
In either way you use the above event to read the input and act accordingly...
SteveL13Author Commented:
Doesn't this break the rules of a properly normalized database?  Just a question.
John TsioumprisSoftware & Systems EngineerCommented:
Why it breaks the rules and how ? if you enter a filter that originally was not supposed to be shown nothing is the other case is your choice to save the record.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.