I want to use multiple recordsets at the same time to gather my data but I do not want to create x number of recordsets. I just want to create one and switch between recordsets. I think you can do this with .ActiveConnection but I'm confused reading the MSDN on this. Can anyone help me out?

Thanks,
Greg