You can't add a dollar sign in front of the parameter name in the recordset SQL statement. You also don't need to add the Limit statement, it will be added automatically.
Your SQL statement would be:
SELECT COUNT(pil_knotg_info.FID) AS FIDCount
FROM pil_knotg_info
WHERE pil_knotg_info.FID = FID_num