I am getting the error: " No value given for one or more required parameters. "

My code is :

 insnamequery = "SELECT INDIVIDUALNAME.NameID,[FirstName]+' '+[LastName] AS Name, LastName FROM INDIVIDUALNAME where Name='" & dropinspectorname.SelectedItem.Value & "'"

 Dim insnamesource As New OleDbCommand(insnamequery, myconnection)
            Response.Write("**" & insnamequery & "**")
            Response.Flush()
            Dim insnamereader As OleDbDataReader
        Error Line***********
    insnamereader = insnamesource.ExecuteReader() **********
            While (insnamereader.Read())
                insnameid = insnamereader(0)
                Response.Write("**" & insnameid)
                Response.Flush()
            End While

            insnamereader.Close()

I am getting what i sthe problem. Please help.

Thanks alot

Regards Nidy

I don't see anything wrong with what you have. Confirm that all of the field names are correct. That's usually where that error will come from.