After some testing yesterday I decided to change the way my DE form loads:
https://www.access-programmers.co.uk/forums/threads/open-form-to-new-record-but-with-a-specific-value-in-text-box.309738/post-1671935
This means using
DoCmd.OpenForm "frmInspection", acNormal, , , acFormAdd, acDialog...