Combo box on a form

K

Kim T

I've got several combo boxes on a form, I've made a table for each combo box
and populated them. How can I make it where the end user can type in an
answer and it add to the list already there?
 
J

John W. Vinson

I've got several combo boxes on a form, I've made a table for each combo box
and populated them. How can I make it where the end user can type in an
answer and it add to the list already there?

See the online help for "Not In List". The combo has a NotInList event which
fires when the user types a value that's not already there; you can write VBA
code to add the user's typed entry to the table, or open a Form to let the
user enter more extensive data.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top