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.