How to Get a Numeric Field to Autoincrement

  • Thread starter Thread starter JAJansenJr
  • Start date Start date
J

JAJansenJr

I tried to get a numeric field to autoincrement by using the autonumber
property but got an error message that only one autonumber field is
permitted per table. Any suggestions on how to get a field to increment by 1
when a new record is created are sincerely welcome.
 
Check mvps.org/access for "Custom Autonumber".

The generic sense is that you'll create a procedure that looks for the
largest (current) value and adds 1 to get the 'next' value.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top