Use of wildcards

[benc]

I have create a query that get its criteria froma form entry with the code below.

[forms]![search bookings]![customername]

However this does not allow the use of wildwards when typed in the form as it shows no records. e.g.

*Acme*

IS there anyway that my code can be change of the use of a different character can be used to do this.

Thanks in advance.

 

[Mile-O]

Change your criteria to this:

Like '*" & [forms]![search bookings]![customername] & "*'

 

[benc]

That worked however

Like '*" & [forms]![search bookings]![customername] & "*'

needed to

Like "*" & [forms]![search bookings]![customername] & "*"

with the double speech marks