I have 5 comboboxes where by the items in the second combobox depend on the section in the first one, the third depends on the second, and so on.
Challenge i have is when i make the first selection all the file get populated with the first element
below is the example of the code i use. this is a windows application for vb.net
dadp = New OleDb.OleDbDataAdapter("SELECT * FROM [villageUnit] WHERE ((([country])= '" & cmbcountry.SelectedValue & "'));", db)
dT = New DataTable : dadp.Fill(dT) : dadp.Dispose()
vu.DataSource = dT
vu.DisplayMember = "villageName" : vu.ValueMember = "vid"
vu.BindingContext = New BindingContext : vu.SelectedIndex = -1
Me.hhcode.Text = ""
Catch inv As InvalidCastException
Catch ex As Exception