Multiselect List Box

[mixedguy]

Hi I need to create a form with mulitple "Multiselect List Boxes." I need help with the VBA code.

Please look at the attahment, it's a screen shot of my Form.

At the top you'll see three Mulitselect List boxes - lst_Project, lst_PE, lst_Approp - the users should be able to select from any combination of the three Multiselect list box. example - they can select from the lst_Project and lst_PE, or they can just select lst_PE and so on...once they select from the Multiselect List box they click the button at the bottom and it'll requery the subform according to their selection criteria.

Thanks soooo much in advance!

 

[dcx693]

Do you know how to use the multiselect listbox selections in a query? If not, read the following: Use Multi-Select List boxes as query parameters. Also check out Martin Green's series of articles on Access and SQL, especially this one: Access and SQL Part 5: More Instant Queries.