auto number is skipping by one for each entry

[sheela]

Hello:

I am using a form to enter records to the table. Through
this form the user is able to enter multiple records.
They type the values and click on save button. Then a
message box shows up asking whether they have more data to
enter.
If they have, they say yes and type the data and click on
save. This process goes on until they say no to enter more
records.
Everything seems working fine. Except the auto number is
skipping one, for each entry.


I am using DAO recordsetclone in the forms program. I am
closing this recordsetclone at the end of the program.
Still it is skipping one number for auto number field. How
do I fix this one?
Any help is appreciated.
TIA,
Sheela

 

[Rick B]

Posting your message in multiple groups wastes people's time. Please limit
your posts to one group so that you do not have multiple people working on a
solution for you.

Rick B


Hello:

I am using a form to enter records to the table. Through
this form the user is able to enter multiple records.
They type the values and click on save button. Then a
message box shows up asking whether they have more data to
enter.
If they have, they say yes and type the data and click on
save. This process goes on until they say no to enter more
records.
Everything seems working fine. Except the auto number is
skipping one, for each entry.


I am using DAO recordsetclone in the forms program. I am
closing this recordsetclone at the end of the program.
Still it is skipping one number for auto number field. How
do I fix this one?
Any help is appreciated.
TIA,
Sheela

 

[sheela]

Sorry i didn't think that way.