Combo boxes, can you add data?

[Guest]

I have a combo box on myy form called Client Names, this is linked using the
wizard to a table with Company names. I can select the name I want, but it
must first exist in the Names table. Is it possible to use the combo bo now
as it is, to select a company name but also to allow someone to type a new
company name in the combobox and have the new name added to the names table
without opening the Names form first?

 

[Douglas J. Steele]

There's an example of how to do this in
http://www.mvps.org/access/forms/frm0015.htm at "The Access Web".

Note that you need to set the combo box's LimitToList property to True in
order for it to use the NotInList event.