Link to home
Start Free TrialLog in
Avatar of MariamAlsowaidi
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.
Avatar of bmatumbura
bmatumbura

Filter ComboBox2's data source using the ID of the field selected in ComboBox1
Avatar of MariamAlsowaidi

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
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial