Setting Formats & Validations for New Records (1 Viewer)

Rich_Lovina

Registered User.
Local time
Today, 23:18
Joined
Feb 27, 2002
Messages
225
I have 3000 sample records (converting for first time to access), such that last record has a unique personnel ID no of 3071, this field also being my primary key. How do I set to autonumber for new records such that they start at 3072, incrementing by 1?
Is this done in format or validation box from input form design?
 

Jack Cowley

Registered User.
Local time
Today, 14:18
Joined
Aug 7, 2000
Messages
2,639
Search Help for Autonumber and then select 'Change the starting value...'. It will lead you through the process.
 

Users who are viewing this thread

Top Bottom