Using a ComboBox to Refresh another Combo Box

Question

1.00/5 (1 vote)

See more:

Hi there,

Sorry to ask a silly/stupid question...

I'm new to all this and i'm in the process of learning VB .NET using Visual Studio 2010...

I just had a question because I cannot seem to find the answers anywhere on the internet... also we are not upto this part in class yet..

Say I have 2 combo boxs... cmb1 and cmb2.. both are datasets from an access table..

how do I make it so cmb2 refreshes based on the value of cmb1?

eg; if cmb1 is say, period 1, then i want cmb2 to only show results bases on items I have in period 1?

Any help would be greatly appreciated

Ross the newb

Posted 27-Oct-11 15:19pm

Forge199

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Answer 1 · 2011-10-27T15:34:00

Solution 1

What you seem to want is called a cascading drop down. Search for that term and you will find plenty of info. Its more complicated than there is space here to describe adequately

Posted 27-Oct-11 15:34pm

Not Active

Comments

Forge199 27-Oct-11 22:04pm

Hi, thanks for getting back to me...

isn't that just for web based applications?

[no name] 27-Oct-11 22:09pm

You didn't specify the environment, but no the technique may differ but the theory is the same.

**Manoj K Bhoir** · Answer 2 · 2011-10-27T18:55:00

I wrote the following subrutin which will help you to refresh Second ComboBox based on the value selected on the first Combobox.
Just Copy this code in your application and call this method on ComboBox1_SelectedIndexChnged.

VB

Public Sub FillCombo(ByVal idfiles As String, ByVal table As String, ByVal Combo1 As ComboBox, ByVal Combo2 as ComboBox)
        objda.SelectCommand.CommandText = "Select " & idfiles & " FROM " & table & " Where FieldName=" & Combo1 & ""
        Try 
            dr = objda.SelectCommand.ExecuteReader   'Exectuing query
        Catch ex As OleDb.OleDbException
            MessageBox.Show(ex.ToString)       'Providing Error Message
            ErrorLog(ex.ToString)              'Creating ErrorLog
        End Try
        While dr.Read                          'Reading DataReader Items
            Combo2.Items.Add(dr.Item(0))     'Adding Items Into ComboBox
        End While
        dr.Close()                         'Closing DataReader Object
    End Sub

Example for calling above method

VB

FillCombo("FieldName", "DatabaseTableName", ComboBox1,ComboBox2)