How do I reload a combo box after NotInList Event fires?

When the NotInList event fires, I use the NewData and DAO's SEEK command to see if the NewData exists in a table. If so, I want to suppress error messages from ACCESS, and I want to requery the combo box and have NEWDATA displayed in the dropdown list.  

The query which supplies  the fields in the drop down list  is based on the contents of a text box ("CustShortName"). When the SEEK is successful, I store in the text box the value which should cause the requery to be successful. I'm missing something, because the combo boxes drop down list is empty and I get the standard ACCESS error about the string not being in the list.
I
After SEEKing NEWDATA and putting the correct data in "CustShortName", I set Response = acDataErrAdded and exit the NotInList event.  Help, anyone?

Steve
SowleManRetiredAsked:
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.

John TsioumprisSoftware & Systems EngineerCommented:
Somewhere you must have something wrong because i also use Response = acDataErrAdded and it works fine without requery
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Sounds like your doing everything right, but keep in mind what field your combo is bound to.   For example, a customer ID, but your displaying a name in the combo.

New data is what the user typed and is what the combo is looking for to do the match up.  That may or may not be the bound field.

Jim.

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
SowleManRetiredAuthor Commented:
Thank you, Jim. Your experience paid off for me. I was reminded that the binding field can be different than the displayed field(s). I'm off and running!!
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.