Search

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

Hi

I'm looking for a code to allow me to search for a phone
number in my DB and disply all the results in a combo box

I tried to do it and I put in my query

Tel like *[forms]![FrmRechercheContact].[form].
[txtNumTel].value*

But it seems not working I have always the message that
there is a . or ! that dos not accept in my query

Thanks
 
chris said:
I'm looking for a code to allow me to search for a phone
number in my DB and disply all the results in a combo box

I tried to do it and I put in my query

Tel like *[forms]![FrmRechercheContact].[form].
[txtNumTel].value*

But it seems not working I have always the message that
there is a . or ! that dos not accept in my query
Click to expand...


The operands of Like must be strings. In addition to Rob's
comments, it should be written:

Tel Like "*" & [forms]![FrmRechercheContact].[txtNumTel] &
"*"
 
Back
Top