I think that is exactly what I have (Except the $ before Paramvendor_id_WADAvendors) Is that correct?
yes, that is correct.
And on line #88 it has this code$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.
