Not sure what happned there!
I used to have the same problem a long time ago and managed by making the id the very last item before submission.
Might be too simple an idea because I don't know how your users actually obtain the id. Could also make the field an autonumber field in the access table - then the users don't have to input anything? ...