Re: search for simliar text
Access does not use the % character as a wildcard, instead it uses the * character. Try this queury instead.
qry=" SELECT Restaurants.RestName FROM Restaurants"
qry = qry + " WHERE Restaurants.RestName LIKE" + "'" + "*" text1.text + "*" + "'"
Search_Data1.RecordSource = Qry
I hope this helps you.
Sean Wilkening
IVR/CTI Programmer Analyst
Re: search for simliar text
qry=" SELECT Restaurants.RestName FROM Restaurants"
qry = qry + " WHERE Restaurants.RestName LIKE '%" & text1.text & "%'"
Iouri Boutchkine
[email protected]