Multiple selections in List Box - to display selected records

[riccardo]

Hi everyone,

I'm relatively new to Access so if anyone can help me with this it would be greatly appreciated.

I have a table: 'tbl'.
It has 4 columns: 'group', 'type', 'unit' and 'value'. Group-type-unit is a hierarchy.
There are 1000+ records in 10 groups, with 50+ types and 100+ units/values.

I have a basic 'display all records' query.



I need to be able to select multiple 'groups' on a form, presumably using a list box, and have all the associated information from all 4 columns display on my split form so I can view it then export it as an excel file. As you've probably guessed I'm having some trouble.

I have tried building a form and including a list box where multi-select and unique values = yes, however when I switch to form view the box doesn't work according to either of those parameters, therefore the whole thing doesn't work. It seemed to work once but promptly broke for reasons beyond my comprehension.

If one of you Access masters could point me in the right direction that'd be great.

Cheers.

[June7]

Applying multiple listbox selections as filter parameters will require VBA code. Review: http://allenbrowne.com/ser-50.html