Append query duplicate records

[hardyd44]

Hi Guys

This is a weird one

I have done this dozens of times, but something is happening I have never hit before.

I have a a form bound to a table, but it has fields that are unbound to this table within it, these fields are either combo or text box's - data is entered into the field and and using an append query this data is inserted into a different table, The form closes and reopens each time to reset the fields

Now the weird stuff:

add a record first time - 1 record added to table

add a new record second time - 2 duplicate records added to table

add a new record third time - 4 duplicate records added to table

I have tried unbounding the form from the table, changing field names and allsorts - to no effect

Has anyone any ideas?

Thanks

Dean

 

[Trevor G]

Have you tried grouping the append query and tell it to use the first record only.

Is the form you are using showing all the records so they could be duplicated again when you run the query?

 

[hardyd44]

Trevor,

the form was already on current record only to stop unintended changes happening

But the grouping by trick worked and stopped the duplicate records - so Thank you for that.

Still baffled why it was happening - I have used the same technique to enter data into a table dozens of times

Still problem solved

Thanks again

Dean