Thank you for your post. I haven't tried resetting the record source based on the users selection as in your sample. My VBA skills are lacking but I think the example might help. Unfortunately I don't see a way to eliminate the first step as there are hundreds of projects, each having as many as...