add to a value list

[awake2424]

How do I allow a user the ability to enter in text into a combo-box so that it saves to that record? Thanks.

 

[vbaInet]

1. What is the Row Source of your combo box?
2. Which field(s) is/are visible?
3. How about using the Allow Value List Edits and List Items Edit Form properties of the combo box? Much quicker to implement.

 

[TJPoorman]

I think the property you are looking for is Limit To List under the Data tab

 

[vbaInet]

>>>> add to a value list <<<<

I think the property you are looking for is Limit To List under the Data tab

This adds to the field bound to the form not the underlying table/query (or Row Source) of the combo box. But then again, perhaps this is what the OP was trying to convey.

 

[awake2424]

I apologize about the dual post. I posted this on the forms section and do not know how to delete a post.
http://www.access-programmers.co.uk/forums/showthread.php?t=267644

The row source has the 3 values in it that appear in the dropdown and the entire field (Institution) is visible. When I change allow values edits, limit to list, or list items edit form, I get the text entered isn't an item on the list and when I go to add it I get the linked table has been changed on the server, the last entry will not be saved. I do not want to add the entry to the list, rather save it to the individual record. Thanks.

 

[TJPoorman]

Try the following settings:
Allow Value List Edits - No
Limit To List - No
List Items Edit Form - Leave it Blank