Like problem

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
Try This:

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

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

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