Is that correct?
yes, that is correct.
$Paramvendor_id_WADAvendors = "-1";
if (isset($_GET['vendor_id'])) {
$Paramvendor_id_WADAvendors = $_GET['vendor_id'];
}
wouldn’t that set the variable for the query?
yes, that creates _a_ parameter, but it is the parameter for the vender query. you need to create a new one for the vender notes query rather than try to reuse the other one. the problem is that you are copying and pasting code rather than using the DW Recordset dialog to create the query.
in the recordset dialog, go to advanced view to create the paramater.