Linking multiple tables and queries in form

[zrome]

Hello,



I am relatively new to Access so am a bit confused on how to do this. What I am trying to do is create a ListBox in Access where I can (multi select enabled) choose multiple names of people. Upon selecting the names of these people, I want Access to be able to go to few other queries and tables (specified by me and same every time) and obtain information from numerous columns for that 1 specific row (persons name). Finally, it should be displayed in a nice looking report format.

What I have done so far:
I have created a form with a combo box (4 actually as I need 4 sets of information). Upon choosing a value from the 1st combo box, the rest of the combo boxes are filled with the same value (persons name). Each combo box obtains information from a different table and outputs to a text box so these 4 combo boxes are outputting different numerical values (for the persons name) to the text boxes below. In Gist, this works for me. The problem is: I need to be able to do it for multiple names (list box selection) at the same time rather than doing it one at a time.

Any advice? Thanks!

[June7]

Reading the values in a multi-select listbox requires VBA code. This example http://allenbrowne.com/ser-50.html shows how to do that to build filter criteria for a report.

I don't understand what you are trying to do with the comboboxes and especially don't understand how would work with multiple selected items.