add to a value list

awake2424

Registered User.
Local time
Yesterday, 20:48
Joined
Oct 31, 2007
Messages
479
How do I allow a user the ability to enter in text into a combo-box so that it saves to that record? Thanks.
 
Last edited:
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.
 
I think the property you are looking for is Limit To List under the Data tab
 
>>>> 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.
 
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.
 
Try the following settings:
Allow Value List Edits - No
Limit To List - No
List Items Edit Form - Leave it Blank
 

Users who are viewing this thread

Back
Top Bottom