Search from 3 list boxes

[cleg7700]

Thank you in advance.

I have a form that contains 3 list boxes, each of which are multi select. I would like to have my user select option(s) from each list box and press a search button which then opens a report and shows the results in a sub report. I;m not quite sure how to approach the search button.

I am somewhat new to VBA and if you need more info please let me know and excuse me if I am not using the correct terms!

Any help is appreciated.

[ranman256]

you cant. Queries do not recognize multi list boxes.

so the only way would be to write vb code to scan the listboxes, run an append query to put each selected item in a 'picked' table.
These picked tables are then joined to the main data to pull the results.