auto numer is skipping by one number

  • Thread starter Thread starter sheela
  • Start date Start date
S

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
 
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.
 
Back
Top