List Box Rather Than Subform

[kmyoung]

Good Friday, All...

I have a form who's recordset is a make-table query. Fields include Group No. and Level. Is it possible to add a multi-select list or combo box rather than a subform to identify those employees matching the Group No. and Level on the main form? I'm hoping that as employee's are selected from this list box, the related email address will populate a second list or combo box. Once the second box is populated with email addresses, I'll send those employees an email using a field in the main form as the message text.

Is this possible?

Thanx in advance for your help.
Regards, Karen

 

[FoFa]

Yes, but why go through all that trouble when you have the info. on the subform? Why not pull it from there? I guess I do not understand why you want to use combo/list box for it?

 

[kmyoung]

Okay, here's what I'm trying to accomplish.

I have a main form which I want to use as the recordset for an on click event to send emails. The main form includes a field called message that will be used as the message text on an email. The email addresses for each respective record are identified on a subform. Lets say the main form has 3 records and each record has 50 email addresses tied to it via the subform. I want to have a button on the main form that, when clicked, will generate one email for each record, targeting all recipients for that respective record. I want to send 3 emails rather than 150. If I reference a field in the main form for the text message and reference a field in the subform for the recipients, how do I distinguish within the code which recipients go with each message? I thought that, by including a combo box that listed the appropriate recipients on the main form, I could then just reference the combo box as the To: field within the code and have it cycle through each record.

Am I on the wrong track? If so, any suggestions or alternative solutions would be greatly appreciated.