Copy / Paste some fields

[isnpms]

God Morning.
I have a little access system with 2 tables, one form and one sub form.
The main table (tblMain) is for general data: tCod (Key), tName, tAddress, tZip, etc.) and the second table (tblSecond) is for input daily data where some are different (Date(), total value, etc) and others are the same (Name again - get it form main form with default value function - RG, CPF, Bank account, Bank.).
What I need and I’m trying to do is a way to copy/paste only these value that always repeat and need to be in this second table (for future report need) every time I make a ADD NEW action at this subform.
I made a query using the fields Name, RG, CPF, BnkAcc and Bank assigning at the Name criteria =[Forms] ![Mainform]![Name] or =[Forms] ![Mainform]![Subform]![Name] (who makes the same work) wondering this could help but couldn’t.


Is there any way to use, for example, a command button or get or set focus or something else to copy these data from the existing register and pasting them to the new register?
Case not possible this way, with that query example could it be? I just don’t know how to write it to automatic populate the fields.
Any help will be very welcome.
Thank you.
Ivan Sinigaglia (Brasil)

[NoellaG]

Hi,

I can't see why you would repeat some fields from your main table in the second one. Apart from repeating the PK of the main table as FK to the related table, each table should only have the fields in it that depend on the PK field of that table (2nd normal form).
When you want to create a report, just create a query for it that holds all data needed for the report.

grNG

[isnpms]

Because sometimes it may change but others no.
I want a way to copy/paste them everytime i need.