Setting criteria to search parcitular letters

[spleewars]

quick question: in a criteria i need to set a code than even the slightest amount of letters return a search. for example in the "Description" column:

"Dell Inspirion D5000"

Lets say a user writes 'pirion' in the criteria. All the records with those letters will return a search. I tried 'like "*" but doesn't work.

 

[pr2-eugin]

Using like will sort out.. but using it should be carefully considered. Use like as follows..

Like "*" & [Forms]![Name_of_the_Form]![Name_of_the_Field] & "*"

Say if you enter 'am' it will return 'Amy','Sam','Liam','Jamal'... As you have enclosed it inside * and * which it means 0 or more characters presceeding and proceeding the Value in the Field.

Hope this helps !