Solved

Filter combobox using the value of another combobox

Posted on 2009-04-02
4
537 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
4 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 70

Accepted Solution

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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

831 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