No value given for one or more required parameters

[princessk1]

I am getting this error message:
'No value given for one or more required parameters' when I am trying to open a recordset. Does anyone else know what is causing this error.
This is my code:

Set rs = CreateObject("ADODB.Recordset&quot
Set cnn = CreateObject("ADODB.connection&quot
cnn.Open getconnection
cmd.ActiveConnection = cnn

SQL = "SELECT * FROM TblFilterClient WHERE ClientID = " & _
txtClientID

cmd.CommandText = SQL
rs.open cmd

Thanks

 

[addsd]

Hi Princess !,

What's the Data Type of ClientID in the table ?.


Regards,

Ahmed
ajewahar@sa.dhl.com

 

[ASMA]

Try
SQL = "SELECT * FROM TblFilterClient WHERE _
ClientID = '" & txtClientID & "'" (single quotes 'inside' double quotes)


if txtClientID is text type (not numeric)