Select record from query to append

[greeknl via AccessMonster.com]

I have a database and I display some records in a subform according to some
criteria (so far so good) Now I would like to select on the subform a
selection of the records shown (result of the abovementioned query) and then
perform using a commandbutton some actions related to the selected records.
Lets say I have a query which finds all residents in a certain area/city, and
I display them on a subform. Now I would like to select from those displayed
some persons to say send a email to using a commandbutton after the selection
has been made
I hope I clarified my question good enough to get a specified answer

Is this possible and how to go about it?

 

[Guest]

Hi,

You could use your query as the rowsource for a multiselect Listbox. Then
you can add a command button that uses the selected records. You can find
information on
this by doing a google search or checking out these links:

http://www.databasedev.co.uk/query_using_listbox.html
http://www.fontstuff.com/access/acctut11.htm

Hope this helps
Hunter57