Copy a Single Field From Multiple Records & Paste Into Another Table

[justinschmidt]

I am very much a beginner at access, and can't for the life of me
figure out how to do the following. Can anyone help?

See screen shot here
http://img397.imageshack.us/img397/9584/accesshelp0xg.jpg

I have 2 Tables running 2 subforms

Table 1 (Under Phase Codes)- Contains all Codes X (Phase Code ID) for
Project Y
Table 2 (Under Production)- Contains production rates for Codes X
(Phase Code ID) for the week of MM/DD/YY

I need to figure out a way to automatically copy all Codes X (Phase
Code ID's) for Project Y from a query on Table 1 into Table 2. I only
really need that one field copied, but there will be about 20
autonumbers for every project. So I need to be able to grab 20
autonumbers from 20 different records in the query, and then paste them
into Table 2 into 20 different records.

Production Rates will then be manually entered each week (therefore
each Phase Code ID will have many entries in Table 2, one for each
week).

 

[justinschmidt]

If that doesn't work. I am trying to get a workaround to work, but
cannot figure out how to properly call a main form procedure from the
subform. Any ideas on that?