I have an unbound form called [ReportsForm] on which there is an unbound combox box called [HidePPIDetail] (which has a value list of yes or no).
I also have a report called [usysbFormPPIAtCommencementR]. This report gets its data from the [ClientDetails] table. The report is grouped by [PPI] (primary presenting issue) and lists the clients who presented by PPI. I also have a count [=Count([ClientID])] which counts the total number of people for each PPI.
If I look at the Section_Detail properties of the report called [usysbFormPPIAtCommencementR], I can manually change the visible control to No. This gives me only the Totals.
What I would like to do is get the user to select whether they want to hide the detail on the report by selecting yes or no on the [ReportsForm].
Then in the [usysbFormPPIAtCommencementR] report's ???? OnOpen ???? event get it to display the report depending on what the user has chosen.
Can anyone please give me some advice/code on this?