Access - Allow Value List Edits - Default MS Error Message
Posted on 2014-01-12
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.
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?