Creating a Report, from a Form, based on values selected in a List Box.

[liamfrancis2013]

Hi,

The idea is i want to create a Form, from a Field in my Table, containing the names of a group of people in a list box. From which i can generate a Report.



I need the report to return all the other fields for the names i have selected.

Basically i just want to get back records for the multiple people i have selected. Alternative methods would be fine

[ranman256]

Create a 'picked' table. When user double-clicks the person in the 'available' list, run an append query to add that person to the 'picked' list.

In a query Join this picked list to the data table on the person, only those in the list will get data.

you can remove everyone in the list with a delete query.