The only way you can achieve this is if you put strSQL1 and strSQL2 into an array and made a call like this:

tempstr = strSQL & Cstr(arr[i])

You can not dynamically reference variables in the manner you have laid out above.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========