Select Multiple Items In The List To Show Detail In The SubForm

[aamer]

have a form "AcTitlNPurDteDetailFrm" on this form there are two combo boxes for "Account Title" (CboPPP) and "Item Discription" (SchDescripCbo) when they are selected I get the detail on "AcTitlPurDetailSubFrm"
This is working perfectly. Whereas I actually want to use combo boxes "Account Title" (CboPPP) and "Select one or more Items" (DiscripCbo) to select multiple items in the list and
Detail to show on "AcTitlPurDetailSubFrm". I need help to perform this task.


A sample Db is attached to better understanding.

Sample DB.zip

[June7]

A multi-select combobox must be bound to multi-value field.

Controls used to enter/select filter criteria must normally be UNBOUND (as you have in your form).

DiscripCbo is actually a listbox. Might change name to DiscripLbo.
For using an UNBOUND multi-select listbox to build filter criteria, review http://allenbrowne.com/ser-50.html

If you really want to use multi-select combobox, this would require saving selections to a multi-value field then VBA managing a recordset to expand MVF to retrieve data elements and build criteria.

[davegri]

You really don't need the second combobox. The multiple selections can be made from the listbox.
Your design is complicated by the form/subform having no linking relationships, so the subform recordsource has to be controlled by code on the main form as selections are made.

Sample-davegri-v01.zip

[aamer]

Thank U. I will reverse engineer the sample you attached to understand how you fixed it.

[davegri]

Thank U. I will reverse engineer the sample you attached to understand how you fixed it.

OK. If you get stuck and need some detail help, PM me.