Filter/Seach for Part of Field 1

[Dilly]

I have created a form that filters records depending on the imput to a set of fields. So you can search on part No, Aircraft Etc. At present it will only search on exact matches. Is there anyway of filtering on partial matches? I would like to filter on description so that entering something like "bolt" will bring all records containing Bolt in the description.

 

[welshone]

You can do :

Like [Forms]![Search]![searchsurname] & "*"

in your criteria.

where a form is called search and a text box is called searchsurname