Solved footer totals in subform

[ClaraBarton]

I do not know what you did, Gasman, but it now works. I've copied it in, compared, confused, don't care. Moving on. Thank you very much.

 

[Gasman]

I mentioned in a previous post not to open a recordset with records if you are just adding records.
I used to use WHERE 1 = 0
Then I found out there is actually an option already.

RecordsetOptionEnum enumeration (DAO)

Office developer client VBA reference documentation

learn.microsoft.com