You are AWESOME 🙂

I have a ton of stuff being selected so instead of doing what you recommended in the select just before the select I did this

...

So how do I get around this if I am not sure which of the variables will contain values. The stored procedure is being called like this

Set rsResults =...

'Use MyDatabase' should accomplish this

Since you asked specifically about "Use" I assume you have tried it and it didnt work?