Multi-Value ComboBox on Form - Used as Criteria in Query for a Report

[nickmit11]

In the current database I designed, I have a form with an unbound combobox. This combobox serves as the criteria for a Query that then feeds a Report. It is simple, efficient, and works very well.



My superior would like for this combobox to allow for multiple selections so that when the report is produced more than one selection would show on the report, instead of running the report two different times.

So far I am able to produce an unbound combobox that allows for multiple selections that populate (separated by commas) in the combo box. I think the next step is to get the Query to read the multi-value selection but I am unsure how to get the Query to do this. Is this something that has to be done through SQL, VBA, a combination, or is it as simple as criteria in the Query? If it is impossible I would definitely like to know that too! Any insight is greatly appreciated!!

[June7]

What you describe is normally done with a multi-select listbox and it does require VBA. Review http://allenbrowne.com/ser-50.html

[nickmit11]

Thanks for the link! Is it still possible to do it using a combobox? Or is it solely compatible with a multi-select listbox.

[June7]

I don't even know how you get an UNBOUND multi-select combobox. AFAIK, must be associated with a multi-value field. I don't use multi-value fields.

[nickmit11]

Doubling back I was incorrect about it being UNBOUND. It is linked to a multi-value column on a table. However this multi-value column's sole purpose is to store what is selected from the combo box on the form, it does not store more than one instance of what is selected in the combo box, i.e. it is always changing whenever the combo box changes. Is that making sense or not really?

[June7]

Okay, sounds like you need a better understanding of what a multi-value field is and how to use the data saved in that field. https://support.office.com/en-us/art...C-6DE9BEBBEC31

Is this a multi-user split database? Multiple users will conflict with each other changing the values in that field.

[nickmit11]

I've definitely never encountered anything like this before so you are right, thanks for the additional link.

This is indeed a multi-user split database.