I have created a small database that imports data from an accounting package and displays results in a specific format. I display the data using a sub-report, rather than sub-form because it easily allows for grouping and sub-totals. I have placed a combo box on the form to enable preliminary data filtering. I am using Access 365, which supports double-click events on a report cell, which I use to facilitate drill downs on the data. I plan on inserting some check boxes on the parent form to allow the user to select which columns to print so the desired result will fit on a single sheet of paper. i can also use the same check boxes to limit the columns displayed on screen if the user has a narrow monitor (e.g. a laptop)
The only drawback is that I haven't figured out how to display the column headers on the sub-report. Once I scroll down the sub-report headers disappear and don't readily come back. I could put them on the form but then I run into issues syncing the form and sub-report if the user scrolls across the page using a narrow screen size. Ideally I would like to lock both the header and a couple of the sub-report columns. Is any of that possible, and if so, how?
Thanks very much for your comments. You've confirmed what I thought but Experts always amaze me with what you're able to accomplish so I thought it wise to ask. I also hoped that MS may have added some functionality to freeze panes and columns of a report when they introduced the expanded features and I just didn't realise it.
This application is actually best suited to a pivot table but the user is used to an access program I wrote for him 10+ years ago that generated half a dozen reports based on data extracted from his accounting system via an ODBC Link. A recent upgrade of that software meant the link would no longer work so he asked me to find another way of providing the data. This new functionality in MS Access made it very easy to give him a report that provides the perfect overview - everything he wants to see on one, simple report. And he now has the ability to double-click on a column to open a second report that gives a list of the detailed data that went into the summary overview. So it was too easy and too tempting not to use the report as a quasi-form.
I will do exactly as you suggested - put the headings on the form and give him some pre-formatted, condensed report options to print.
Thanks again for your time and support.
Rob