I have an append query named y1CompareTablesAdd. When I append it manually it works fine. There must be a problem with the VBA in the module. When the module activate the VBA it creates an extra record. What is strange is the table it appends to has an autonumber ID field, and also the append query does not display the extra record before appending. On the image it can be seen, I think it is got something to do with the line starting with InsertInto.