Computer Learning Zone
Getting the New AutoNumber ID in Microsoft Access VBA
8:47
When VBA adds a new record in Microsoft Access, you often need the AutoNumber ID immediately afterward. That ID lets you open the exact order, customer, or log entry your code created instead of guessing based on the highest number or the newest-looking row.
In this episode, Richard explains why relying on Max(ID), sort order, or the last record in a form can fail in a multi-user database.…