Subform records missing an index
I dropped a subform onto my form and can successfully add records to it however the foreign key linking the subform & mainform is not saving when the subform record is entered. Thus I can enter subform records but cannot go back & see them entered against the main record in the form. The foreign key isn’t saving. My subform query has a field specified against the foreign key though in the criteria though so I wonder what I am doing wrong.
I dropped a subform onto my form and can successfully add records to it however the foreign key linking the subform & mainform is not saving when the subform record is entered. Thus I can enter subform records but cannot go back & see them entered against the main record in the form. The foreign key isn’t saving. My subform query has a field specified against the foreign key though in the criteria though so I wonder what I am doing wrong.
