The answer to this is probably really simple, but I can't work it out!
I have a main form (Student) which has a sub form (Enrolments).
On the sub form I have a combo box (StudentStatus) with 'Active', 'Withdrawn', 'Completed' and 'Non-starter'. When the status is changed to anything other than Active it prints a report. However, when the report is printed, it prints 1 report for every record in the subform. I only want to print the one report for the current record I am on.