You have probably been asked this a thousand times or more, but is there anyway to get the autonumber to start at a different number than 0 or 1, I have tried this, it kind of done this to a 'point' but left all the other entries stuck at that number, which isn't exactly ideal

http://office.microsoft.com/en-us/access/HP051887741033.aspx

http://office.microsoft.com/en-us/access/HP051887741033.aspx


I can't get to the 'Required Field'

Perhaps you don't need to, have you followed the instructions?
Is it a new table?

Brian

Perhaps you don't need to, have you followed the instructions?
Is it a new table?

Brian

Ah right yes, I see, thanks

but - although you can manage an autonumber, you shouldnt need to or want to.

If you think you need to, then you should be adding an appropriate sequential control field to your master table, and managing the numeric sequence of that.

You cannot guarantee an intact numerical sequence with an autonumber field