I have a lengthy SQL statement using two variables.  Inside a nested loop, 

the SQL is changed, and I need to reload the recordset with the new SQL 

statement.  The problem is that if I try to change the SQL, I get an 

"Exception Occurred" error.  I have tried closing the recordset, setting 

the recordset = nothing, yet it still doesn't work.  I hope to post the 

code tonight or tomorrow, but until then...anyone got any ideas?



James