Thank you both for your quick replies.
Since I've never worked with VBA before (first time ever per my boss's request), I just have to get up to speed in a hurry and learn on the fly.
As for the "qrySQL", do I need to define it here or somewhere else in the project? An example may help...
Hello,
I'm in the process of creating and exporting multiple csv files at each change in the AdvisorID. However, I keep getting the Error "3265" -Item not found in this collection at the line: CurrentDb.QueryDefs("qrySQL").SQL = strSQL
Does anyone have any idea why this happens...