Help with not in list

[Guest]

When a user enters data in a combobox that is not in the table I would like
to open a form to allow the data to be entered. I would like for the data
entered into the combobox to be filled into the second form with out typing
it again. Then I would like the comobox to be filled with the new data and
the cursor moved to the next feild in the original form. Please help.

 

[George Nicholson]

http://support.microsoft.com/default.aspx?scid=kb;en-us;161007
Use NotInList Event to Add a Record to a Combo Box

Provides 2 methods: adding a record via a form or strictly via code.

HTH,

 

[[MVP] S.Clark]

This will require some custom VBA coding. If you are not versed in the art,
there are plenty of professionals here that would be happy to help.