New values added to autofill-entry based on table

[MS_Access_User]

Perhaps not the correct place to ask, but I was unsure which of the other sections this should go in.



I am new to Access, and I wish to create a database of, say dog breeds. I know how to make a dropdown list based on a table, but is there a way of making it so that new entries which are not found in the table, are automatically added to the table?

For example, if the table already contains "German shepherd", then the word will fill out when the user types in "German". However, if the user wish to write "German (some other breed)", is there a way of making it so that that new word is added to the list for future entries?

[CJ_London]

use the 'on not in list' event

see this link for a number of suggestions

https://nortonsafe.search.ask.com/we...doi=2016-09-01

[MS_Access_User]

Great, thanks. I works like a charm.

One question that I didn't find a good answer to; is it possible to use a similar function for a combobox where the user can select multiple values?

[warmslime]

Yes, you can also use the List Items Edit Form property (with Allow Value List Edits set to yes). In that case you could have a form pop up where the user could confirm the new breed's addition (and perhaps enter more data in other fields). But if you want to keep it simple yes, use the NotInList event for both list boxes and combo boxes.

[CJ_London]

a combobox where the user can select multiple values?

I presume you mean a combo based on a multivalue field - if so, probably, I don't used them myself so can't really suggest anything. I'm guessing you will need to base your criteria on the .value property