Appologies for the late reply - been on a sabbatical. Did you get this issue resolved? If not, it should be possible to store the subform names and the different SQL strings in arrays and loop through the forms setting the record sources.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!