My page pukes when I ask for a record based on a screen variable. If I put a hard string in the RecordSet such as WHERE member_id = '12345', it works perfectly. If I say 'WHERE member_id = 'FindNbr'
and specify the variable as 'FindNbr' and '%' and 'Request.StringQuery("member_id", it gives me an error. I've tried variations of the RunTime Value, but apparently, I don't know what to put there.

CharlieB

No:
'WHERE member_id = 'FindNbr'

this isr ok:
'WHERE member_id LIKE 'FindNbr'