Rick,

In AC 324 you asked to let you if anyone wants to see how to store multiple data on the not in list event.
Well for now I am anyone and I was unable to figure it out over the last couple of month.

What is the best way to solve the problem at hand; Using comboboxes to select country, region, city, company, product. All in their own table with a relational ID to the former combobox/table. Untill the first combo where to fill in data that is not yet in the list.
The first box is no problem and works fine using the not in list for it needs only its own data.
Next cbox and all following have no data because they relate to the former cbox.
Now anyone (which by the way is me) needs to fill in at least 2 new data-items; lets say in the region cbox the region and the relating countryID which is not yet part of the CountryTable.
How to do this so everything works properly?

Thanx in advance
eddy p-nut