Copying module

[JOhn]

I have a module that updates and copies across records in
a table. The problem is when I do the update to the
record it applies it to all the records. I only want it
to update the new records that are copied across. Any
ideas?

 

[user]

make a query that update the selected records you want first and then a
second one that copy the updated records (then with a different select
as they just been modified) in the table...