That error suggests that the when you created the variable, the name was not exactly the same as what was used in the SQL.
Remember, the variable names are case sensitive. paramOrderID is not the same as ParamOrderID (Note the capital P) If you continue to get an error, post a screen shot of the Recordset window showing the SQL and the variable.