Combo box and select query


Sep 4, 2004
I have a basic windows form in VB. I am using the following code to connect to a SQL database. The database has two tables. The goal here is have a user make a selection in one combo box and populate the other with only the records that match the query. The first combobox is populated by table tblsymbols column process. The second is populated by tblparts and should fill the box with all part numbers where the process columns match.

Private Sub frmParts_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

Dim sqlprocess As String = Nothing
sqlprocess = "SELECT * from tblSymbols"
cboprocess.DataSource = KanbanDataSet.Tables(1)
cboprocess.ValueMember = "Process"
cboprocess.SelectedValue = -1

End Sub

Private Sub ProcessComboBox_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles cboprocess.SelectedIndexChanged

Dim strprocess As String = cboprocess.Text
Dim strpart = "SELECT PartNumber FROM tblParts WHERE Process = strprocess"

End Sub

Any help would be great.
Top Bottom