typable combo box??

Hi,

I have a combo box which looks up the authorname table.
This combo box is pretty long and I am trying to make it easy for users to find this name from the combo box.

I am looking for a functionality like as you type, possible names wil show up.

Is this doable using the combo box? What control do I need to use?

I need to find a name and save it.
dkim18Asked:
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.

Helen FeddemaCommented:
This is a built-in feature of Access.  As you type, you should go to the next match in the combo box list.  Is that not happening?
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
dkim18Author Commented:
You are right. Thank for pointing that out.
It is working. The problem was I tied the primary key and name together to display so when the users were typing a name it didn't show up becuase it started with number then name.
Thanks.
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.