Steve, I'm helping the OP with a Microsoft template. There is SO MUCH inappropriate and confusing code and macros in those templates. I've worked on ALL of them, converting dozens of IDs into more conventional _PK and _FK names, cleaning up code converted from embedded macros to VBA, removing attachments, table lookups, and plain logic errors. After that, I needed to correct the row sources dozens of comboboxes, and fix myriads of queries containing different data names. It's a work in progress.
I modified the current template, time and billing, with major enhancements for a forum user early last year. We exchanged 169 emails to get it right. That DB had a lot of the above corrections applied, but needed the enhancements stripped out to suit the current OP.
To get a functional DB for the current poster, I anticipate dozens of message exchanges, code fixes and form/report changes, all requiring a path forward without sidetracks. That's why I mentioned a PM in post #5 with the intent of exchanging email addresses. This DB is nowhere near ready for prime time and I hope the OP will work with me via regular email, as 169 forum posts is not practical.
I appreciate your good intent, but suggesting changes to one line of the template's original code to a different equivalent format is a drop in the ocean at this point. ¯\_(ツ)_/¯