auto number is skipping by one for each entry

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

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


"sheela" wrote in message
...
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

Sorry i didn't think that way.
-----Original Message-----
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


"sheela" wrote in
message
...
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


.