Thanks to @Gustav for altering me to your post.

As my article made clear, when the Total Row feature was added, The Access team didn't add a VBA approach to enable / disable the total rows in form VBA. 17 years on from 2007, they aren't going to do so now! However, the code I provided in my article using CommandBars does the job perfectly

Application.CommandBars.ExecuteMso "RecordsTotals"

Indeed, I supplied an example app which shows this code in use in a datasheet form. NOTE: So I could include buttons on the datasheet, its actually a split form with the single record view hidden

So I'm not sure what functionality you want that I haven't provided. Feel free to email me using the link in my article if you need further help. We can always add further info to this thread later for the benefit of others.