Combo List

W

wal50

I have a combo box; Row source type = value list; with several values. I
would like to have the drop down offer the list selections that it does and
allow users to enter new values and add them to the selections. Is this
possible? how? and is it a bad idea.

Thanks,

wal50
 
J

John Vinson

I have a combo box; Row source type = value list; with several values. I
would like to have the drop down offer the list selections that it does and
allow users to enter new values and add them to the selections. Is this
possible? how? and is it a bad idea.
Click to expand...

Set the Limit to List property of the combo to False, and the user
will be able to type anything they want. That value won't be added to
the value list though. You may want to create a Table to hold these
values, and use the VBA code you can find by searching for "Limit to
List" at http://www.mvps.org/access to add new records.

And yes, it's often a bad idea. If a user can't spell correctly, they
may not notice the correct entry in the list and add their own
imaginative misspelling of it; it will then be stuck in the list until
you or someone else edits it out.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top