You're right it's not SQL. I thought it was, because all of this was working right before I moved the tables to SQL, and with the autonumber being assigned at the end, I thought it was another change like that. In the interests of being thorough, I have done quite a bit of troubleshooting and have ruled that out, as well as running macros, though I still haven't found the source yet.
Thanks for your help. I'm sure I"ll get it.