Hello.
I currently have a form called frmAlpha that is based on tblAlpha.
This form the following fields"IncidentID", "Activity", "City", "Province", and "Country". The "Country" retrieves all of its values (Row Source) from another table called tblCountryList. tblCountryList contains a list 150 countries, and nothing else.
I want to add an additional field to frmAlpha called "Region" where I can list ONLY the following values "Asia", "Africa", "Europe", "Latin America", and "North America". Next, I want that when I enter a value into my "Country" field (combobox) on my form, I want it to automatically update the "Region" field (also a combo box), based on tblCountryList.
What is the best way to do this???
Things I have tried:
Adding an additional field to tblCountryList were I list the regions.
Adding the "Region" field to frmAlpha via the ComboBoxWizard.
However, when I do this, the combo box has 150 possible choices (because the Regions are shared between multiple countries.)
I hope this makes sense...
Thanks