I have two comboboxes. One has items I input because there are only 4 choices to choose from. Combobox 2 depends on what is selected on combobox one, but I don't know how to filter out combobox 2 based on what is selected on combobox 1.
Here is what I have:
Food_ComponentsCombobox has the items Milk, Meat, Fruits/Veg., and Grains/Breads
Food_Items_as_PurchasedCombobox is linked to a database that contains the columns Food Components and Food Items as Purchased plus some other stuff.
If I choose Milk in Food ComponentsCombobx, it should populate the Food_Items_as_PurchasedCombobox with only those food items that are milk.
I feel like I am going in the right direction, but I can't figure out the code that specifies I just want the Food Items the user selects.
This is my code and I advice that it is not working:
Private Sub Food_ComponentsComboBox_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Food_ComponentsComboBox.Click
If Food_ComponentsComboBox.SelectedIndex = 1 Then
.DataBindings.Add("Milk", Me.USDABindingSource, "Food Components", True)
.DataSource = Me.USDABindingSource
.DisplayMember = "Food Item as Purchased"
.ValueMember = "Food Components"
When I run this I get a message "Cannot bind the property "Milk" on the target control" and it points to Food Components on the .Databindings.Add line. I know I'm doing this wrong, but I don't know how to make this work. Again, I need for the user to choose from 4 items on combobox 1. Depending on the item chosen, combobox2 should populate itself with only the items related to the item chosen. Can anyone help? I'd really appreciate it. Thanks!