too few parameters

[matrixknow]

Hola,

I have a sql to feed my recordset. I need a parameter from a form. If I type the value literal eg 83 it works. The reference to the formfield works also.
When I try to include the variable or the form reference in my WHERE clausule he said to few parameters. I thinks its a syntax trouble ?

Dim iID_CCT As Integer
iID_CCT = Forms![F_01_AR_FICHE]![F_02_AR_FICHE_CCT]![ID_CCT]

& "WHERE T_02_CONTACT.ID_CCT =  iID_CCT " _

 

[PHV]

& "WHERE T_02_CONTACT.ID_CCT = " & iID_CCT _

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixknow]

 & "WHERE T_02_CONTACT.ID_CCT = " & iID_CCT & " " _
         & "ORDER BY T_02_CONTACT.CCTFORNAME;"

thanks ! I don't see clear but you have to close also the var iID_CCT & " " _

 

[lespaul]

or add a space at the beginning of the next line:

& "WHERE T_02_CONTACT.ID_CCT = " & iID_CCT _
         & "[COLOR=white yellow] [/color]ORDER BY T_02_CONTACT.CCTFORNAME;"

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins