I would like to add a contact log to the database I am creating.
I have figured out how to create a functional search combo box to browse through records and edit the information on those records.
I am using the following Macro on the search combo box:
Apply Filter: [YthID]=[Forms]![frmIntake
Now, I am moving into relational tables ("many" contact logs to "one" person). I have been able to add a subform (a contact log) to this form to enter data only. And it works.
I would also like to add a table showing the summary of these contact logs either on this same form (as a subform) or on a popup form.
How can I link the search combo box (located on the Form Header) to the primary key (YthID) on a subform? What should I put on the Macro builder?
Thank you in advance!