I hope someone can help me on this problem. i have a database (accdb) from access that i want to filter by several comboboxes.
1 st combobox filter row 1 (BaseM)
2nd combobox filters row 2 (Umat) based on the results from the first combobox.
3rd combobox filter row 3 (Gmat) based on combobox 2
private void cmbBaseM_SelectedIndexChanged(object sender, EventArgs e)
matBaseBindingSource.DataSource = matBaseDataSet.MatBase;
CMBmMat.DataSource = matBaseDataSet.MatBase.Select(US => US.USnumber).Distinct().ToList();
matBaseBindingSource.Filter = "USnumber = " + cmbBaseM.SelectedItem + "";
I get an error on the last part
matBaseBindingSource.Filter = "Umat = " + cmbBaseM.SelectedItem + "";
with the message
System.Data.EvaluateException: 'cannot find column [A].'
I have tried so many things that i'm not sure what the way to go is here.