Form/Subform linking and adding records.

M

Mike

I added a subform to the main form. The table in the
subform has many records to one record in the table for
the main form linked by an 'ID' field. If I want to add a
record into the subform, how do I get the 'ID' field from
the main form to the 'ID' field in the record of the
subform fiel automatically?
 
J

JohnR

If the subform is properly linked to the main form, the
update should happen automatically. A backup option would
be to set the Default Value for the ID field on the suform
to Forms!MainForm!ID
 
Top