Searching a GDBGrid

[lewihenda9]

Hello all,

Basically, I have a GBGrid which is linked to Access. It displays all the names of people entered into the database. I want to be able to search the database to find a name. So far my code only allows me to find a record/name when I search the EXACT name in the search bar. E.g. If I search "Jack Venn" I will get one result for that record. However, if I search "Jack" I get no results. Is there any way to be able to enter a keyword or part of a name and get results?

Private Sub cmd_search_Click()
Set rs_customer = db.OpenRecordset("select * from Customer where Customer.Customer_Name like'" & txt_customersearch.Text & "'")
Set Data1.Recordset = rs_customer
End Sub

[dilettante]

The pattern supplied to LIKE needs to be a pattern rather than a complete value.

So search for "Jack*" when using DAO.