I think using the Macro would be the preferred way to go as multiple selections will always have to be made for the report types.

I've not used formfield check boxes before (if using the macro could I not continue to use the content control check boxes?) , how will they be referred to in the code? and what will i have to change in the code to clarify how multiple selections would affect the conditions statement.

Thanks again for you help, I've been stuck on how to do this for a while now and your help has been fantastic!!!