That's OK. I did mark it solved and then basically post a new question.
I've also reposted this question on the programming board. You may want to look at that as I have more detail there.
https://www.accessforums.net/program...ord-12563.html
Anyway... The records should always be entered in consecutive order but I don't know how to account for user error that might make that not true.