MS Access - Copy form field to sub-form field

[ARW456]

I would like to copy the field from a form field to a sub-form field.

I don’t really care if this is via a macro button in the sub-form or as an event associated with a record entry to the sub form – which ever is easier (or possible!)



I have a series of tables:

TBL_Names (represented by the first 5 fields on the left)
TBL_Methodologies (first sub-form on left side of image: fields “Names” & “Methods”)
TBL_Systems (second sub-form on left side of image: fields “Names” & “System”)
Etc. etc.
The common field for all tables is “Name”.
What I want to do is enter new records into TBL_Names via the main form and all other tables via the sub-forms where required, however I do not want to keep typing or physically copying the name “Joe Bloggs” (as in the example shown) to all subsequent sub-forms needing new entries.

Am I right in assuming I can enter a new record for “Methods” in the appropriate sub-form and then have an event copy the contents of the “Name” field from the main form to the “Name” field in the sub-form – either on enter or click (or any other appropriate action)?

(Please ignore the presence of the copy button in the sector 1 sub-form – it was a failed attempt to achieve this process via macro !)

Windows XP SP2
MS Access 2003