Access Running Sum Question for Numbering a Subreport's Records

Question

I am having difficulty figuring out how to number my subreport's records. I have a main report, which provides indentifying information for one record. Within the main report is a subreport, which provides records assoicated with the main report. I wanted to number these records from one to how ever many records there are. I tried the running sum feature in properties (i.e. textbox = 1, running sum = over all) and it works when the subreport is open, without the main report; however, when the main report is open the subreport running sum doesn't function (i.e. it just shows the number 1 for every record).

I understand that this is a main report/subreport drawback. Does anyone know how to get around this or a VBA solution that I can add within an On Open event?

Thank you,

DFM

Answer 1

I did a quick test using Access 2003 and your approach works fine.

I created a textbox in the sub-report in the detail section:

Control Source = "=1"
Running Sum = "Over All"

Something else must be going on.