Auto-Numbers

Wendy · Jul 23, 2003

How do you set the "Auto-Number" control to start from a
number other the 1?

Arvin Meyer · Jul 23, 2003

Wendy said:
How do you set the "Auto-Number" control to start from a
number other the 1?

Append a record to it from code or a query with 1 number before the one you
want to start at. After you add your first "real" row of data, delete the
dummy row.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Mike · Jul 23, 2003

Wendy, There is a great little blurb in www.mvps.org that
tells you all about it. Good luck. Mike

Becker · Jul 23, 2003

Wendy......

Key in this address: www.mvps.org/access/

That is the address of "The Access Web". When you get there click on
"Tables" and there is your answer.

Put it in your "Favorites". It's a great site.

Becker
(e-mail address removed)