Improve company productivity with a Business Account.Sign Up

x
?
Solved

Filter combobox using the value of another combobox

Posted on 2009-04-02
4
Medium Priority
?
547 Views
Last Modified: 2013-12-25
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
Comment
Question by:MariamAlsowaidi
3 Comments
 
LVL 11

Expert Comment

by:bmatumbura
ID: 24047803
Filter ComboBox2's data source using the ID of the field selected in ComboBox1
0
 

Author Comment

by:MariamAlsowaidi
ID: 24047896
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
 
LVL 71

Accepted Solution

by:
Éric Moreau earned 1000 total points
ID: 24047998
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Native ability to set a user account password via AD GPO was removed because the passwords can be easily decrypted by any authenticated user in the domain. Microsoft recommends LAPS as a replacement and I have written an article that does something …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question