Form Submit Issues - Insert into failed: you must satisfy the constraint 'pkey'

Thanks for getting back to me on this. I have had the issue pop up again and have reposted it here - Insert a record - via a form - PKEY error showing up across multiple reports

What I find odd is the fact that all my reports work fine with this function until they dont randomly?

Thanks