I am currently creating a product lookup system for a project of mine, however from reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it will not handle more than a simple "SELECT, FROM".
CurrentEntry = Variable storing the users entry
"SELECT Product_Name FROM tbl_ProductInformation WHERE Product_Name LIKE '*" & CurrentEntry & "*'"
The outcome of this query is then put into a listbox.
Is there anyway to make the OLEDB SQL query work so that the returned entries will correctly narrow down to the entered text.