Not sure if this is possible, but I wanted to use a FillBy query to populate a datagridview on a form I have. The issue I have is with the Where clause. If I hard code the item to lookup it works fine
Where TrustName = 'Smith Trust'
I run the form, press the "FillBy" button at the top, and the datagrid is filled with all the values from the Smith Trust.
However, I want to user to be able to select the TrustName from a combobox on the form. So I figured:
Where TrustName = Combobox1.[Text] (as an aside, I didn't put the bracket around the "Text" part, vb.net does this automatically)
So now when I run the form, press the "FillBy" button at the top, I get the following message "No value given for one or more parameters"
I've tried various remedies I've found (putting single and double quotes, + signs), all to no avail.