Hi,

does anybody know what the syntax is for bringing a value from a field in an existing Recordset into the runtime value box in an advanced SQL statement?

thanks in advance for any help!

Paul

Make sure the 1st recordset has the field in it you want to take,

In the second you will have something like:

Select *
Where Fieldname = MMColParam

when you specify the variable MMColParam in the runtime value add the following:

recordsetname1.fields.item("Fieldname".value

This will filter the second recordset on the value you have in the first.





Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

Brilliant! Thanks, I was using PHP in a previous job and have now changed.

This will stop me looking stupid performing even the simple tasks!

thanks once again

Paul

guys i have tried this so many times, using your method and i keep getting this error message
Parse error: syntax error, unexpected '(', expecting T_VARIABLE or '$' in /homepages

or i get this
Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE or '$' in /homepages/16/d147460636