Copy record to new record in same table

[guitarzycki]

Another newbie question here.......


I have a table that has a composite primary key consisting of two columns "ID" and "Serial" and a bunch of other descriptive columns. Duplicate values are enabled in both primary keys. What I'd like to do is to create a copy of a record and add a value to the "Serial" column. I have been bashing away trying different types of queries like the append and update but I'm just running around in circles. Could anyone steer me in the right direction on this?

Thanks ahead of time!

[pbaldy]

You'd want an append query to add a new record. An update query would edit an existing record. Sounds like you'd want an append query that pointed to a form control in the criteria, to identify which record to duplicate. It could get the new value for Serial from a form as well.