Unanswered: New Subform Record - Set link field in code
I have a form with a subform. The form and subform are linked through a key (SiteID). The subform displays all records the match the SiteID on the main form. The problem I'm having is when the user wants to enter a new record on the subform. I would like to have the SiteID on the subform automatically filled out with the SiteID on the main form so the user doesn't have to manually type it in.