add newly entered value to combo box A2002

[Tina]

I have used the lookup feature in my tables to attach a
combo box to my forms. Example: I have a serial number
table and an equipment table I want to be able to type my
serial number into the equipment form and have it saved in
the serial number table this should make it available in
the combo box on the subsequent records on the form. I do
not want to have to goto a separate form to add to my
combo box. I have found help topics that tell me this can
be done but no examples of how to do it.

I have Access 2002.

Help
Thank You, Tina
..

 

[Ken Snell]

I think you're going to have trouble because you're using the lookup field
option in your table. What that means is that what you see * is not * what
is in the table. As such, adding a new field without using some type of code
will not work, because you need to use the LimitToList property (set to No)
but you can't do that because your bound column is not the first visible
column.

Here is a URL with info on how to set up a NotInList addition, but it
involves VBA code:
http://www.mvps.org/access/forms/frm0015.htm