I am new to Access and need to create a form with a subform. There will be a combo box linked to another file containing client IDs. When the client ID is selected, it needs to pull those record(s) for the client selected. I'm seeking to understand the following:
1) Is this a form with the combo box in the header?
2) How do I link the client ID from the header to the subform.
3) Is the data entry section in blue one subform and then I create a 2nd subform as a table? If so, how do I link all 3 client ID fields? or is it one form using a split form?