Save Key Value To Child Table on Subform

[Guest]

I want to create a form with the main form containing only the MemberID and a
subform containing the membership history. I have a created a parent table
with MemberID and a child table containing history data with MemberID and
Effdt as keys. I've tried creating a main form with MemberID with a
datasheet subform (for the history entry) to enter the data but the MemberID
key is not saving to the subform/history table. How do I do this?

 

[Scottgem (MVP)]

Make sure that the correct linking fields are selected in the data tab.
Or use the wizard to place the subform.

 

[John W. Vinson]

I want to create a form with the main form containing only the MemberID and a
subform containing the membership history. I have a created a parent table
with MemberID and a child table containing history data with MemberID and
Effdt as keys. I've tried creating a main form with MemberID with a
datasheet subform (for the history entry) to enter the data but the MemberID
key is not saving to the subform/history table. How do I do this?

View the Subform's Properties (not the properties of the form contained in the
Subform control, but the "box" itself). On the Data tab find the "Master Link
Field" and "Child Link Field" properties - these should both be MemberID.

John W. Vinson [MVP]