I have an append query that works ok but now that I have added record to the form where it is run from, it wants to add ALL of the records!
The Primary Key on this form is EventID and I dont need to append it to anything since the table it is appending to has it's own Key for that record.???
Primary Key on check register form is RegID and that is the form where the data will be displayed.
Table where data is coming from is named tblEvent (Primary Key EventID) and Table where data is going to is named TReg (Primary Key RegID)
I need some suggestions please.