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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble associating parent form record to subform's record 1
First Subform record gets modified when closing form 3
Set Change Event on Control from Nested Subform 0
VBA Syntax for subform record source change 6
Set focus in a specific record within a subform 1
Main Form and two Subforms 2
Using Linked Combo Boxes with a subform 1
Subform with no records 8

Back
Top