encapsulate a form field with wildcards

[bunji]

I have a query that has a criteria from a field on a form...

[forms]![frmSearchCriteria]![Company_Name]

I would like to put wild cards * on eitherside that it uses will bring up with anything with what is written into the field.

I have tried putting wild cards on the form field and on the criteria of the query. Any Ideas? thanks

 

[KenHigg]

Like "*" & [forms]![frmSearchCriteria]![Company_Name] & "*"


???

 

[bunji]

So Simple should have thought that!!! thanks

 

[KenHigg]

.
.
.
.
.
Cool