Nifty Combo Box Example - MS Access

This example is in answer to a particular question on Access World Forums (AWF) - The OP wanted to enter the name of a country into a text-box on an MS Access Form and then have a combo-box to display the continent/region? related to that selection. I suggested an alternative method, using a combo box to select only the Country and have the continent/region extracted from the ComboBox and displayed in a text box.

I used a data-set I downloaded (Excel Format) from the internet to create the entries in the table for this MS Access demonstration from this URL here:- Countries of the world.xls

The information for the Microsoft Excel file was created from information provided by this website here:-

http://gsociology.icaap.org/dataupload.html