No, I'm afraid that won't work. A linked subform only displays records that are already related to the record in the main form.
Besides, I strongly suspect that you want each report sent to several recipients, and each recipient to receive several reports. That's a many-to-many relationship. For that, you'll need a third table. Call it DISTRIBUTION, and give it fields ReportID and RecipientName. While still in design view, click the Lookup tab at the bottom, and set the properties as follows.
For ReportID:
Display Control: Combo Box
Row Source: REPORTS
Column Count: 2 (or 'n' if ReportName is the nth column)
Column Widths: 0 (or "0,0,..." n-1 times)
Limit to List: Yes
For RecipientName:
Display Control: Combo Box
Row Source: Recipient Name
Column Count: 1 (or 'n' if Recipient Name is the nth column)
Column Widths: empty (or "0,0,..." n-1 times)
Limit to List: Yes
Save the table, then open the Relationships window. Create a relationship from REPORTS.ReportID to DISTRIBUTION.ReportID and from RECIPIENTS.[Recipient Name] to DISTRIBUTION.RecipientName. Click the Enforce Referential Integrity check box for each of these.
Now if you open the DISTRIBUTION table in datasheet view, you'll have a pair of combo boxes for each row that let you select report names and recipient names.
To make a form/subform as you described, base the main form on REPORTS and the subform on DISTRIBUTION. Create the subform first, and drag Recipient Name and ReportID from the field list to the form. You'll automatically get combo boxes for them, because of what you did on the Lookup tab. You'll want to make the ReportID invisible. It duplicates what the main form will already show, but you have to have it there in order to add recipients to the underlying DISTRIBUTION table. Make the form as short as possible, with just enough room for the Recipient Name combo box, and set the form's Default View to Continuous Forms.
When you create the main form, drag the Report Name from the field list to the form, and drag the subform from the database window to the form. Make the subform control long enough to show many users.
When you save the main form and switch to Form View, the subform will display recipients for the selected report in the main form. You should also get a "*" line at the end of the subform list, in which you can add a new recipient. Each new recipient will add a row with the ReportID and RecipientName to the DISTRIBUTION table. Rick Sprague
