I agree with @mike60smart, so I modified your table relationships. See
DocumentControl_PB_r1_ss.accdb
Then I started modifying your forms... didn't get far because I don't understand your process. You do have a fair amount of link/junction tables, more than I would think necessary.
In "
DocumentControl_PB_r1_ mod_ss.accdb" I did make a couple of forms: see "frmDocuments" and I further modified your tables and relationships.
Your naming conventions is pretty good.
I use suffixes "_PK" and "_FK" to have the Pr and FK fields stand out.
And only one reserved word used: "tblVersionCycle.
Path".
Soooo, "Path" of what??? Add another word to Path...."VersionPath"??
My $0.05 worth........