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
 

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

Populate main form from subform record 0
First Subform record gets modified when closing form 3
Unremovable horizontal scroll bar on subform 1
Trouble associating parent form record to subform's record 1
DLookup in Continuous form 0
VBA Syntax for subform record source change 6
Adding data to MS Access from csv file 0
Main Form with Subforms 5

Top