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.