Report

Hi Claire,

Thank you for your question and welcome to the forum.

You would need to create a conditional macro with the condition relating to the value of an object on the from and then output the record or records relating to that condition.

Alternatively, you could create a query which displays the results needed. Then create a macro to open the form and use the Filter option to apply the criteria and then output the results to a report.

I hope this helps.

Regards

Simon