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.

How can I do this?

Thanks,
Becky McDermott