Form Autonumber does not match the number of records on the table

M

Manny

I have a form where I entered Tenant information. Every time I open this
form the Auto number increments by one. For example the Auto number in is
20 even though I only have 2 records in the table

I expected that the next number would give me is the number 3 for the next
record.

Any suggestions how this could be fix?

I am a novice with Access.

Thank you, in advance for your help.

Regards,
 
S

storrboy

Autonumbers seem to be a daily topic lately.
If the linear sequence of the field is important to you, don't use
Autonumbers. It is intended to be a simple method of assigning a
unique index to a record. If that index needs to mean something to you
or your users, you should employ a different method. The help file
contains examples of how to re-order the field, but you will come into
this situation again. Either don't worry about the number, or use a
different indexing method.
 
R

Rick B

There is nothing to fix. An autonumber is simply a unique number that can
be used as a key. Your users should rarely (if ever) see the autonumber
field. It is an internal item, not something for the end user.

If you care about the number, you need to create your own numerical field
and create code that will find the highest entry and add one to it when
creating a new record.

For exact information on how to do this, look at previous posts on the
topic. Search for "incrementing field" or "increment value".

There are several here...
http://groups.google.com/groups/sea...=microsoft.public.access+increment+field+form

Good luck!
 
Top