Creating maling list in a form from a table

[stupiet]

To anyone who can help,

I created a table of a list of people who you potentially want to send some information to.
I'm really new to VBA but I think I need to use it to get this done.
What I want to do is when a user clicks on send a form pops up that list all these people you could send it to. This list can change so it's based of a table that you can update.
In front of each person I want to place a check box. So every time someone checks the box that person will be included in the e-mail.

I'm guessing I run a sql query first in VBA that loops through the table for all the names.
But where I'm getting stuck is how do you display the names and checkbox onto the form?

Please help. Very new to this so a well written example would be really appreciated.

Regards,

Stupiet

 

[PHV]

Why not using a multi-select listbox ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[stupiet]

Hmmm, never thought of that. That might be a lot easier! But how do you pass on the information once you selected all the people?

So when you click on the button to send do you write a code that sets e-mail address equal to all of them?

 

[PHV]

In VBA you play with the ItemsSelected collection.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886