Yes, the code puts the number into the report control. This is because although there is a table with one record to hold a number, it isn't part of the report recordset. To make it so would require joining that table to the mash of queries you use to get where you are. There is no common field between them so I took the easy way out.
Hit your vb editor compile button and one error will get caught (assuming what you posted is a near enough copy of what you are working with). See what that is all about, fix it (or temporarily comment out the code line) and keep going. Such issues are potentials for run time errors. Research Option Explicit, and while you're at it, learn about Option Compare as well - might come in handy one day. Make Google (or something similar) your go to place for answering your Access questions.
Hint - when I want to temporarily comment out something in code I use 3 ' (''') because that would likely be unique and easy to find with ctrl+F
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.