When report is opened using
DoCmd.OpenReport stDocName, acViewPreview, the subreport is shown/not shown appropriately, but I cannot use any of my command buttons.
When the report is opened using,
DoCmd.OpenReport stDocName, acViewReport, I can use my command buttons, but the subreport is shown for all records.
How do I show/hide the subreport using DoCmd.OpenReport stDocName, acViewReport
Thank you