Error: No value given for one or more required paramet

[azrina]

Hi all.
I got an error for my SQL syntax.
The error lies in the commented line shows below.

<%
nokpA = request.Form("kp1")&request.Form("kp2")&request.Form("kp3")
set ic = server.CreateObject("adodb.recordset")
ic.open "select * from staf where nokp = nokpA" ,conn 'error is here
    if not ic.eof then %>
    <script>
    alert("Maaf, no KP telah wujud");
    </script>
    <%end if%>

The error tells that:
No value given for one or more required parameters.

I think there must be something wrong with the SQL syntax but I couldnt figure out whts wrong with that line.
So, I need help from you all to explain to me.
Thanks in advance.