garbanzor378
Programmer
I have a table which the autonumber is not update until I go to the next record.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with the AutoNumber in a table
- Thread starter garbanzor378
- Start date
- Status
Are you using a form? Is the auto number field the last in the tab order?
Dawn
Dawn
The autonumber should be created as soon as you start entering the data on the form for the bound controls.
Perchance, is the "autonumber" a number being generated by code to simulate the autonumber? For example, a frequent request for this topic is how to generate a sequential number for a table. A SELECT Max(YourPrimaryKey) From... with the BeforeUpdate event procedure is sometimes suggested as a solution.
Richard
Perchance, is the "autonumber" a number being generated by code to simulate the autonumber? For example, a frequent request for this topic is how to generate a sequential number for a table. A SELECT Max(YourPrimaryKey) From... with the BeforeUpdate event procedure is sometimes suggested as a solution.
Richard
- Status
Similar threads
- Locked
- Question
- Locked
- Question