Combo List

[Guest]

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

 

[Douglas J. Steele]

You need to look into the NotInList event.

There's an example at http://www.mvps.org/access/forms/frm0015.htm at "The
Access Web"

 

[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.

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

 

[Guest]

Thanks for the information and the opinion.

You need to look into the NotInList event.

There's an example at http://www.mvps.org/access/forms/frm0015.htm at "The
Access Web"