Adding data to tables through a combobox field when it is not on list

[Ann]

Hey anybody!

I have a combobox that brings up the department name that is associated with a user. The Department names are in a lookup table, but I would like to be able to add a department name to this table if the person entering the data enters in one that is not on the list. Is there code written out already out there for this becuase mine doesn't seem to work in the NotInList Action Event.

 

[cinnamoncw]

I'm assuming the user is entering data in a combo box in a form. You can create the list so that the user can enter data not on the original list. In table design, go to field properties for that field. Under the Lookup tab, set "Limit to List" to NO. When the user types in a new entry, it will be added to the list. Hope this helps!

 

[Ann]

What I need to do is add to a Lookup table of Departments. In my form I have a combobox that comes from this Lookup table but stores the data in another data table which keeps track of what users belong to what department, not to the Lookup table. I want to not only add the new department (and the user associated with it)to the data table but also to the Lookup Table(one instance of it) so that when I enter in a new user I can refer to the new Lookup Table with the newly added Department. Does that make sense?? I think there is something that needs to be done in the NotInList Action Event?