Ok Vlad, i will look at it. I tried using controls on forms (which are on a navigation form) and I couldn't test the form by itself plus the reports and queries are used in multiple forms. I recently learned about TempVars ((probably here) and gave them a slot.I know Cathy, but we've been running queries and reports long before the tempvars Again, I have not used them in such an extensive way as you are in here, but it looks like a good place to start. For example in your cmdReportPDF_Click procedure why can't the report's (rptCPReport) recordsource reference the form controls directly instead of removing all tempvars and recreating them.
But I thing the biggest impact is in the Illinois_Split procedure where you are adding tempvars for each record while looping through rsJobs recordset (and I don't see any RemoveAll).
Your suggestion to do a RemoveAll within the loop makes sense, so I will add that, thanks.