VbA

Hi Steph

Thanks for your question

I am assuming you are referring to the exercise on the course.

This is fairly simple to achieve. All salespeople and manufacturers are described on the list page. Simply create a procedure that loops through each name. (you could adapt the code that populates the combo boxes for this). At each step, set the variable strName or strMan equal to the salesperson or manufacturer in question, and then call the main sales or main manufacture procedure. This will then run the report for each individual

Hope this helps

Regards

Stephen