Search

[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

 

[RobFMS]

Chris,

Try:
forms!frmRechercheContact!txtNumTel

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Marshall Barton]

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

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

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