Copy all record from subform

[geniussam4u]

i have main form(Review) which contain 2 subforms:


1- Subform (Disciplines) which contain subform (JournalList)
2- Subform (Review Order)

what i am asking about is how with ClickButton i can copy all records in (Journal List) Subform to (Review Order) Subform

both (JournalList),(Review Order) have the same Fields (JournalID,JouranlName,ImpactFactor)

Please help me i am stuck here for long time

[RuralGuy]

It violates normalization rules to have the same data in more than one table. Having said that, both SubForms have Recordset's

[geniussam4u]

Thank you for your Replay

in the (JournalList) Subform = the Top 10 records for chosen Discipline
in the (Review Order) Subform = You choose the journals u want

What i want is button (if the user want to add the Top 10 Journals in (JournalList) to (Review Order) with click not Choose them one bu one.

[David04845]

you will need to rename the fields in the forms so they are all different. then make a button in the record not in the header or footer you will need to click every record individual or make a macro ro tun them all in the VBA go to the on click for that button command and type

field1=field1a
field2=field2a
etc.

make sure the record sets are set to Dy-Inconstant updates. (query also if it has one)

[geniussam4u]

Sorry What do u mean "make a button in the record"

How can i put button inside datasheet