Access 2003. Ihave a Form, and a command button to add a new record. When I click on it , it creates a new record. However, the autonumber does not increment to the next number, eventhough the status bar at the bottom shows that a new record has been added. How do I force it in code after creating new recommand syntax to show the next record number.
I have a docmd.save and also a me.refresh after the add new record command syntax in the code, but it still not does not show the next number. thanks.