how to duplicate a record which is selected by a query using a button

[lvtr1022]

hi,

i have a subform giving the information of a person's history information, and another subform showing the latest information.

i would like to duplicate the latest information as a new record, then modify it and save it.

anyone helps? thanks a lot!

[PhilOfWalton]

Why two subforms?

Surely the moment you enter a new record, it becomes history.

Phil

[lvtr1022]

Hi,

thank you for the reply.

the thing is I want to keep the current record, so i need to duplicate it and modify the duplicated one.

[PhilOfWalton]

Sorry. I'm going to bow out of this, as I can't understand what is wanted. It sounds as if you want 2 current history records.

Sorry

Phil

[lvtr1022]

Thanks a lot! maybe i didn't explain it well. let me give an example.

ID NAME FRUIT START_DATE END_DATE
1 TOM APPLE 1/1/2016 3/1/2016
2 TOM APPLE,BANANA 3/1/2016 5/1/2016
3 TOM BANANA 5/1/2016 7/1/2016
4 TOM BANANA,GRAPE 7/1/2016

There are 4 records for TOM.
if i want to add a record for him, i need to copy the most recently record(now it is record 4) and modify it. but in form we always modify the information which is already in the table.

so how can i copy this record, with multi-value field?

thanks!

[PhilOfWalton]

OK, I understand what, but I don't understand why.

Can the whole thing be done on a continuous subform?
Your button can be used to
1) Move to the last record.
2) Save the fields in your last record into strings and numbers defined in your VBA.
3) Create a new record using those saved fields
4) Requery the subform
5) Go to the last record and modify it as required.

I have never seen anything like this before. I'm curious as to your table structures, and even more curious as to what you are trying to achieve. I looks vaguely like a list of transactions on different dates ... but vaguely is the operative word.

Hope this helps, if not give us more information.

Phil