> I am trying to search a data base in access using vb,...i want to be
t> o enter for example "ne*" and return all results that match in a list
b> ox. Does anyone know the coding for that?
Assumption: connection set through objConn, recordset through objRS,
condition entered in through form.
objRS.Open "select field1, field2 from table1, where field3 LIKE '%" &
conditionVariable & " %'", objConn.
% is your wildcard.
ne% - return all results starting with ne.
%ne - return all results ending with ne.
%ne% - ne is somewhere in your word.