Form/Subform Data Entry

[Jason Gyetko]

I have a form with a subform on it. The main form is set up as single forms
and the subform is set up as continuous forms. They are both updating the
same table, just different fields. What I want is for all fields on both
the main form and subform to be updated into the source table for each
record added in the subform. Right now, it works the way I want it to for
the first record, but then when I enter the second record in the subform,
only that data in the subform is updated in the table, thus leaving all the
corresponding main form fields in the table blank. How do I get the data on
the main form to also be written to the table (for each subform record)?
Hope that makes sense... Thanks.

 

[Jason Gyetko]

I'm building a Certificate of Analysus Picklist table, the form structure is
as follows, all data entry form fields are fields in the Picklist table.

Main Form
------------
Company: XXXXXXX Delivery Date: ##/##/####
PO: XXXXXXX Site: XX
Item: XXXXXXX Packout: XXXXXX
Customer: XXXXXXXXXXXXXXXXXXXXXXXXXX
Comments: XXXXXXXXXXXXXXXXXXXXXXXXXX

Subform
---------
Blend Quantity
XXXXXXXXXX ######
YYYYYYYYYY ######
ZZZZZZZZZZZZ ######

Table should look like:
Cmpy PO Item Cust Cmnts DDte Site Pout Blend QTY
------ --- ---- ----- ------ ----- ----- ----- ----- -----
XXX XX XX XX XXX ### XX XX XX #X#
XXX XX XX XX XXX ### XX XX YY #Y#
XXX XX XX XX XXX ### XX XX ZZ #Z#

If I can do it without a subform that would be great, but I don't know how I
can add multiple records for Blend & Quantity without having to re-enter all
the main form data for each record.