You can do this in the combo's Not In List event, if the value you type is
the actual value to be stored in the lookup table (i.e. the value goes into
the field that matches the Bound Column of the combo, so the bound column is
not zero-width).
Details in:
NotInList: Adding values to lookup tables
at:
http://allenbrowne.com/ser-27.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Dave" <no****@yourbusiness.com> wrote in message
news:43***********************@ptn-nntp-reader01.plus.net...
I have a problem which I know there is an answer to but have so far been
unsuccessful in finding it. It is quite simple in theory. I have created a
form which uses a table for lookup values and they appear on the form as a
list box. I know I can restrict to list or not within the table, but what
I
want to do is to be able to add to the list if the item is not there
(which
you can simply do by typing it into the combo box) but also update the
underlying table to contain it for future reference.