Return results based on a partial search

[TimMoffy]

I have put together a search form for end users and in my query have added the following as the criteria.



Like "*" & [Forms]![frmSearch]![txtclaimno] & "*"

The form names and fields are all correct and I have used this type of criteria before, succesfully.
This doesn't work though. Can anyone see a blindingly obvious bit Ii have missed out?

When i enter the claim number in the search field on the form I get no results at all, whereas if i put in something simple such as
Like *6146* in the query criteria Ii do get two possible claim numbers returned, which is correct.

Brit claim reference
200376146 - GRA-MT-86607
GRA-MT-92758 - 200446146

Stumped and under pressure to deliver. Thanks as always.

[TimMoffy]

Sorted - i hadn't saved the form. As soon as I did the whole thing works beautifully - thanks for looking anyway.

[RuralGuy]

Thanks for sharing your solution.