Like problem

[Chris]

Hi

In my query I want to search all the Phone number where
there is a value that the user enter in a text box :
So that what I'm using in the criteria field :

Tel like Comme (*[forms]![FrmSearchContact].[form].
[txtNumTel].value*)

But it's not working I test

Tel like Comme "*26*" : the results was all the value of
the query

so I change the 26 by the forms value but it's not working

any help please

 

[Dave]

Try This:

Tel like Comme ('*' + [forms]![FrmSearchContact].[form].[txtNumTel].value + '*')

 

[Dave]

Try This:

Tel like Comme ('*' + [forms]![FrmSearchContact].[form].[txtNumTel].value + '*')

 

[Dave]

Try This:

Tel like Comme ('*' + [forms]![FrmSearchContact].[form].[txtNumTel].value + '*')