auto numer is skipping by one number

[sheela]

I am using a form to enter records into a table. Users can
enter multiple records using this form. I am using a for
loop code for this. This table has a field of auto number
data type. For each set of record entries the auto number
skips one sequential number. How do I get the auto number
to get the values in the order with out skipping numbers
in between?
Thank you in advance,
Sheela

 

[Douglas J. Steele]

We'd need to see you code in order to give you a definitive answer, but if
the values of the Autonumber field matters, then you probably shouldn't be
using an Autonumber. Autonumber fields aren't guaranteed to be sequential
with no gaps.