Single Field Combo Box to Add Source Table.

[raychow22]

Hi Forum,



Is there a way to code on a Form with a combo box, but instead from choosing from the list, user enters its own text and that text gets added onto the table where it is sourced from.

Thanks,
Raymond Chow

[pbaldy]

Search on "notinlist", which should turn up the 2 basic methods, both of which use the combo's not in list event.

[Missinglinq]

Actually, the Boys of Redmond made it easier, as of v2007! I assume these instructions are still accurate for later versions:

In Form Design View:

1. Right-Click the Combobox Control
2. Click on Properties
3. Go to the Data Tab
4. In the List Items Edit Form Property, enter the name of the Form where the items in the Combobox were originally entered

When you find out that the item is not in the Combobox :

1. Select any item from the Combobox
2. Right-Click on the Combobox
3. From the popup menu select Edit List Items
4. Your Form will come up automatically
5. Enter the new item's data
6. Close the Form
7. Now select the new Item from the Combobox

Linq ;0)>

[raychow22]

Actually, the Boys of Redmond made it easier, as of v2007! I assume these instructions are still accurate for later versions:

In Form Design View:

1. Right-Click the Combobox Control
2. Click on Properties
3. Go to the Data Tab
4. In the List Items Edit Form Property, enter the name of the Form where the items in the Combobox were originally entered

When you find out that the item is not in the Combobox :

1. Select any item from the Combobox
2. Right-Click on the Combobox
3. From the popup menu select Edit List Items
4. Your Form will come up automatically
5. Enter the new item's data
6. Close the Form
7. Now select the new Item from the Combobox

Linq ;0)>

Hmmm doesn't seem to work. I actually another thing I want to do instead.. If I want to expand the combo list, so like the combo values are "Hi", "There", "Friend". Single values will only allow you to select one of the 3; however, I can make still put them altogether at once because I allow edits. Is there a way to make them able to auto find the word say I started "Hi, "Fr....".... Access should find "Friend" when I type in "Fr".

[pbaldy]

Closing this thread since you've posted an updated question:

https://www.accessforums.net/showthread.php?t=67842