Query as Recordset

[prgwhiting]

Bit of a long one I'm afraid. I've got a database storing details of people applying for a scheme. I cycle my Applicants via code through a series of SQL Statements that return "Pass" or "Fail" decisions. I'm well versed in the old "Too Few Parameters 1 Expected" and have managed to get round this problem by including my where statements as part of the string and the actual criteria itself outside of the string in a variable. ie. "Where TblSchemes.SchemeID=" & ID This always works so if anyone's having this problem do this. I've since been informed by a colleague that I can also move somewhat round the problem by removing all of the (( brackets I've tried this and it works with text, but I get problems with dates and integers. What I need is to be able to store the SQL in a table and using a DLookup call it's entire contents including the Where statement. I need to cycle through the SQL statement's stored retrieving criteria from variables supplied at runtime. Can anyone help with this?