The program I'm working on would use the value of ComboBox1 to filter the results of ComboBox2, i'm using an MS access db that has two tables:
1- Countries, which contains:: countryID, countryName
2- Projects, which contains:: ProjectName, CountryID
ComboBox1 contains a list of the countries, which i managed to do using a dataset
When a user chooses a country, ComboBox2 should only display the projects within the chosen country.