Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 545
  • Last Modified:

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.
0
MariamAlsowaidi
Asked:
MariamAlsowaidi
1 Solution
 
bmatumburaCommented:
Filter ComboBox2's data source using the ID of the field selected in ComboBox1
0
 
MariamAlsowaidiAuthor Commented:
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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now