Its my post, I suppose you mean 15?
Yes but that gives me the same error and I need the sum on main form because I use it for the total sum at the end of the report.
Holy moly, I had it working today for passing the value from sub to main and I lost that backup by accident. Now I have the total sum working and the individual page not, heh. Cant remember what did I do different from what Im doing now.
Because it gives me an error when one of the Me.[sbrSubRep].[Report]![txtFieldOnSubRep] is null (has no value, idk is there a difference) and I try to put it in the txt field, I made a recordset which checks if there are records in the subreport for the same Id as on the main report so WHERE SubRepQuery.Id = Me.MainRepId, if there are records I continue with assigning the control source to the text box, if not I skip it.
But for some reason now the recordset has records but the reference doesnt give any value back, so I get an error again and I had it all working today pfff
Starting to hate these reports
Yes but that gives me the same error and I need the sum on main form because I use it for the total sum at the end of the report.
Holy moly, I had it working today for passing the value from sub to main and I lost that backup by accident. Now I have the total sum working and the individual page not, heh. Cant remember what did I do different from what Im doing now.
Because it gives me an error when one of the Me.[sbrSubRep].[Report]![txtFieldOnSubRep] is null (has no value, idk is there a difference) and I try to put it in the txt field, I made a recordset which checks if there are records in the subreport for the same Id as on the main report so WHERE SubRepQuery.Id = Me.MainRepId, if there are records I continue with assigning the control source to the text box, if not I skip it.
But for some reason now the recordset has records but the reference doesnt give any value back, so I get an error again and I had it all working today pfff
Starting to hate these reports