New problem. I am changing a program to ADO. The following query worked before

"SELECT * FROM qryListCustomers WHERE LastName LIKE '" & txtFind.Text & "*" & "'"

to filter the records by the first letter, or first 2... But know that I have switched over to ADO, it will not. I can just put qryListCustomers after the recordset open statement, and get all the records, but if I try using this SQL statement, I get zero records.

Any ideas? I do not know much SQL, still learning