Hello everyone,

I am trying to get 5 Comboboxes in a row to work properly but did not yet succeed (Access 2000/XP).  Fields to pick are; country, region, sub-region, city and street.
Country is no problem and accepts any new one using the “on not in list” event. Region errored but I was able to fix this one with an “rs2 setting”; this works I think because the country combo has only one value (countryID).
Now on Sub-Region this fix doesn’t work; DLookup doesn’t work obviously. An “rs2 setting” seems not to work although I tried all values in the Region Combo by adding (0) and so on in the “rs2 setting”
Who has “the” answer?

Thanks again
Eddy Geijselaers