Append Query For Single Record

[burrina]

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.

[apryls82]

the form is writing to the Event table before it appends to the TReg table?

maybe you can try adding the Event ID to the query (leave append to blank) and in the Criteria do MAX([tblEvent].[eventID])


I am having a similar issue, its not adding all records, but it is picking 12 of them. in the criteria of my date column i have Date() but its still picking some with other dates.

[burrina]

That gave me a aggregate error. saying I cant have it in the where clause. NO, the form is just where I fire off the event since it is where the scheduling takes place, it runs the append query from the table the form was based on and enter that data into another table. Nothing happens to the original other table.

[burrina]

Okay, I gave up on this approach and instead decided to just use a filtered form as criteria instead and run update from there with ONLY selected records.

Thanks, everyone.