Alright, you guys get the bonus points for making me figure out why the easy way didn't work. I was getting automation error with the Crystal view when I tried this before. I changed the order of the way I reference things and it seems to accomplish what I want (and what you suggested) by having the recordset be a variable along with the form and have the form close it when it's unloaded.

the better news is it seems to have fixed my memory leak...Thanks to both of you.