Form/Subform linking and adding records.

  • Thread starter Thread starter Mike
  • Start date Start date
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?
 
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
 
Back
Top