I want to add a subform to a main form and when I enter a value in the subform it will link to the main form.
The Main form has a field called Invoice ID
The subforms record source contains:
So when I enter something in the Subform I want to store the comments and date in the record source with the Invoice ID stored from the main form. How can I do this?