<div>
Look at this sample<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w03/827802/DBlist.accdb" target="_blank" class="file-inline" title="sample (400 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>DBlist.accdb</a>
</div>


DBlist.accdb

<div>
Als315<br />
when I click on the sample the browser wants to open it in a new browser window.
</div>


<div>
This is one of those - sounds good on paper &quot;features&quot; that turns out to be a double edged sword. &nbsp;In a single user database, it would work as expected. &nbsp;The new value would be saved and would show the next time you dropped won the list. &nbsp;However, in a multi-user database, this is undesirable behavior since it only changes the FE where the change was made. &nbsp;It is not saved in the database and will not be seen by other users plus it will be completely lost when the FE is replaced with a new version.<br />
<br />
If you want the users to be able to update the value lists on the fly, they MUST be stored in a table so that all users are working with the same set of data and when userA adds something to the list, userB sees it. &nbsp;To do this, set the limit to list property to Yes and then in the NotInListEvent add code to capture the new value and add it to the table. &nbsp;You also have the ability to open a form and you would use that method if the lookup list needed more than a single column.<br />
<br />
Personally, I don't like letting the user update combo lists on the fly. &nbsp;It makes them lazy and they create frequent duplicates. &nbsp;So, I have a complete mini-app that I add to all my applications that gives them an interface to use to manage all their lookups. &nbsp;I generally restrict updates to only users with admin permissions so not everyone can just add new items to a list. &nbsp;Of course, this works best with mature lists or lists that are not changed frequently. &nbsp;In some cases, you might deviate and allow direct updates if you were adding items frequently.
</div>


<div>
I am also using the &quot;List Items Edit Form&quot; in A2007 to launch the form I've created when the list populating the dropdown needs to be updated. &nbsp;Thereby, at least in my mind, preventing duplicates, bad data etc..... <br />
<br />
It's not a &quot;value list&quot; that its updating. &nbsp;It IS updating the table.<br />
<br />
My question though was how to replace MS's ominous apocalyptic looking warning that pops up.<br />
<br />
Do you have to essentially code your entire test of if the input value is in the table and if not display a message box and launch the form <br />
<br />
OR<br />
<br />
Can you just override MS's error that pops up with you own Msgbox with a bit of code, leaving MS's remaining internal procedure of what happens with &quot;Allow Value List Edits&quot; and &quot;List Items Edit From&quot;
</div>


<div>
wlwebb: download or open - is function of your browser. You should be able to save this file
</div>


<div>
Using firefox.... &nbsp;No Option when I double click or even right mouse click on the file. &nbsp;It just opens in a browser window with a bunch of symbols... no option to download
</div>


<div>
<div class="content wysiwyg-content">
Good morning all (or afternoon whereever you are)<br />
<br />
I have a Form with a few unbound comboboxes. &nbsp;Haven't used the &quot;allow value list edits&quot; feature on any of my forms before but wanted to try it.<br />
<br />
If the user types the particular number they want selected in the combobox (instead of selecting) it appears that the &quot;Allow Value Edit list&quot; is working if I choose the default Microsoft error message to add to the list. &nbsp;Since in the &quot;List Items Edit Form&quot; I've selected the form I created to add new items to the table that the combobox is populated by the form is opening properly.<br />
<br />
However,<br />
Is there a way to create my own &quot;Error Message&quot; that pops up when they key a number that's not already in the list? &nbsp;I think MS's default one looks ominous giving the appearance that everything's about to blow up.????<br />
<br />
Also, since that feature opens a new form where the table is updated, is there a way that that combobox gets filled in with that number I just input into the table?
</div>
</div>


Good morning all (or afternoon whereever you are)

I have a Form with a few unbound comboboxes.  Haven't used the "allow value list edits" feature on any of my forms before but wanted to try it.

If the user types the particular number they want selected in the combobox (instead of selecting) it appears that the "Allow Value Edit list" is working if I choose the default Microsoft error message to add to the list.  Since in the "List Items Edit Form" I've selected the form I created to add new items to the table that the combobox is populated by the form is opening properly.

However,
Is there a way to create my own "Error Message" that pops up when they key a number that's not already in the list?  I think MS's default one looks ominous giving the appearance that everything's about to blow up.????

Also, since that feature opens a new form where the table is updated, is there a way that that combobox gets filled in with that number I just input into the table?

Access - Allow Value List Edits - Default MS Error Message

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.