I am brand new to subforms and just cannot seem to grasp the concept. Here's what I'm trying to do. I have a table of reports with an AutoNumber field named ID the fileds are [ID] and [REPORT NAME]. I have another table of e-mail addresses with a single field name [RECIPIENT]. I want to assign a list of recipients to each of the reports. I want to do this from a form so I thought I could show the list of reports on the form and display the list of recipients as a subform. I wanted to click on a report name and then click on one or more recipients and have those recipients assigned to the previously selected report name. Any ideas (keep it basic, please)? Thanks. Richard...

For subforms to work, you must have fields in both tables which are the same.

E-mail me direct, and i may be able to help you.

I not saying I can defo. but i'll have a go.

Lee.