What Database are you using? Access, SQL Server, Oracle???

Also, what data control are you using? Is it regular data control or ADO data control??

If you use Oracle or SQL Server then your SQL statement should be:


SQL = "SELECT From Customers WHERE LastName Like " & txtFind.Text & "%"


If you use Access database and a regular Data control then your SQL statement should be:

SQL = "SELECT From Customers WHERE LastName Like " & txtFind.Text & "*"


Regards,

------------------

Serge

Software Developer
[email protected]
[email protected]