Thanks Rachael! You're a life-savior. I spent god knows how many hours trying to figure this out.
Now the only problem I have is with the Activate event. It works great when I just want to view the report. But I am automating the printing of the report and it doesn't work then. Anyone have any...