[2008] Search field problem

[MARCOSAV]

Hi there...

Using VB 2008 with Access database I'm trying to make a search field (txtSearch), but I'm not getting success with code in the button (cmdSearch)...

I'm making this manually, not using the Query Builder, and the result will be displayed in a datagridview (added to the form dragging the table from the Datasource Panel). So, the datagrid is already populated (with no SQL)...

What code must I use for the cmdSearch, to return the txtSearch.Text (or part of it) in the Datagridview ??

I've tried this:
"Select Product, Price, Quantity FROM tblProducts WHERE Product LIKE txtSearch.Text & '*'"

(but it doesn't work)

Any help will be very appreciated...

Marcos.

[jmcilhinney]

Try running this code:

Dim myName As String = "John"

MessageBox.Show("Hello & myName")

and then try running this code:

Dim myName As String = "John"

MessageBox.Show("Hello " & myName)

Compare the results and then take another look at your code.