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.
SteveL13Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & 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
or
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...
0
SteveL13Author Commented:
Doesn't this break the rules of a properly normalized database?  Just a question.
0
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 entered...in the other case is your choice to save the record.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.