Hi all i have spent 2 days on this and i can't figure it out so if there are any wise men out there then please help me.

ok im trying to have recordset2 filter with recordset1, i have this code here

SELECT *
FROM ukproperty
WHERE userid = colname

and then i have var colname

and in the runtime i have this

$_Recordset1.fields.item("userid".value

now when i run this i get this

Parse error: syntax error, unexpected '.', expecting ',' or ')' in /homepages

the thing is i have done what other people said in forums and yet this does not work