I have a form that is a continuous form. The form has a combobox that the user can select from. If the user selects a record that has related records then I want to continuous form to automatically populate additional records with those related records in addition to the record they selected in the combobox.
The form's record source is tblLineItems. Then tblLineItems is "linked" to tblLineItemsAddlComponents. So if the user selects record #6 for example in the main form, I want the records in tblLineItemsAddlComponents that relate to #6 to populate the form.
The tables are setup in Database Tools > Relationships properly.
Can this be done?