Add new items to lookup field

  • Thread starter Thread starter ccizin
  • Start date Start date
C

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)?
 
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.
 
Back
Top