Add new items to lookup field

[ccizin]

I have a ongoing list of items I am entering into a form on a database.
I created a lookup field with the following items for example:

apples
oranges
grapefruit
plums


As I go along I want to add Bananas and Peaches to my lookup field list
without having to manually enter it on the table directly. I would
prefer to just type into form

Is there a simple way to do this (non-VB)?

 

[Guest]

You could try this. Change the lookup field (listbox/combobox) Limit To List
property to No.
Add the the forms On Close property a macro that appends any new items to
the lookup table.

 

[Larry Daugherty]

IMHO there is a much better way, one version contributed by Dev Ashish
years ago:

http://www.mvps.org/access/forms/frm0015.htm

Dev's implementation is less error prone and expressly calls attention
to typographical errors.

HTH