i am just starting with vb.net and have set a connection to an existing access db that i have and am able to get the data displayed on a form.
my problem lies where as i want to setup a basic search. i have added a query to a datagrid to dispaly data based on text in a text box.
now my sql query is this:
SELECT CustID, CustName, CustAddress, CustPostcode, CustTel, CustEmail, CustNotes, CustRoom, CustStayArrive, CustStayLeave
WHERE CustName = '"& SearchBox.text &"'
now i get no errors but also no data gets returned. If i add the actual value of one of the records that one gets returned fine but doesnt really help with a search.
wondered if anyone had any ideas?