MariamAlsowaidi
asked on
Filter combobox using the value of another combobox
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.
Please help.
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.
Please help.
Filter ComboBox2's data source using the ID of the field selected in ComboBox1
ASKER
I'd like to know how that's done. I know i should filter the results using an sql query and enter the results into a dataset, but I don't know how to do that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.