DUPLICATE RECORDS ON APPEND QUERY

  • Thread starter Thread starter Patty
  • Start date Start date
P

Patty

I am having problems with a portion of an application.
This portion involves entering data in which one field is
Autonumber into a temporary work table. On Update, a
macro runs which appends the work table to a second
table. This step is included only because it mirrors
another type of process and the second step is needed. It
does nothing in this instance. The next step is the
second table's contents are appended to a permanent table
which tracks all transactions and assigns an autonumbered
trans no. The form then closes, the work file is then
cleared, the form repopens and data entry resumes. The
issue is that data from the initial table occasionally is
appended to the permanent table twice, of course with
separate autonumbered trans no's. Any idea why?
 
The
issue is that data from the initial table occasionally is
appended to the permanent table twice, of course with
separate autonumbered trans no's. Any idea why?
Click to expand...

Not a clue. Care to post the code? Could someone be hitting a button
twice?
 
The Table you are appending to also has a AutoNumber Field,I presume.Therefor everytime you append data,a unique autonumber is generated within that table.Change the Field Type of the Table from AutoNumber to Text or Number Field


----- Patty wrote: ----

I am having problems with a portion of an application.
This portion involves entering data in which one field is
Autonumber into a temporary work table. On Update, a
macro runs which appends the work table to a second
table. This step is included only because it mirrors
another type of process and the second step is needed. It
does nothing in this instance. The next step is the
second table's contents are appended to a permanent table
which tracks all transactions and assigns an autonumbered
trans no. The form then closes, the work file is then
cleared, the form repopens and data entry resumes. The
issue is that data from the initial table occasionally is
appended to the permanent table twice, of course with
separate autonumbered trans no's. Any idea why?
 
Back
Top