Access to the current task for numbering subreport records

Question

It’s hard for me to figure out how to count my records in reports. I have a main report that contains information for one record. The main report has a subreport, which contains entries related to the main report. I wanted these records to be from one to how many records have ever been. I tried the function of the current amount in the properties (i.e. Textbox = 1, running sum = over all), and it works when the sub-register is open, without the main report; however, when the main report is open, the subtitle amount does not work (i.e., it simply shows the number 1 for each record).

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

Thanks,

DFM

Answer 1

I quickly tested using Access 2003 and your approach works just fine.

I created a text box in an additional report in the detailed section:

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

Something else is going to happen.