Multiple Selection in a Form

[qnikchen]

Hi Everyone,

I am working on a form (UI). Initially I have used a combo box, where you can pick an option and the rest of the form will display only data related to the option/record. My form contains different subform, and most of them are PivotChart form as subform, and also some table with the text box that will display the data according the selection from the combox box or form control.

I would like to know if there is any way beside the combox box, that will allow me to do multiple select. For example in excel, for pivot table, we can do multiple selection and automatically, the pivot table will show the total (let say sum) of the selected option.

Again, my form has pivot chart form as subform, and label with text.

Also, I have a form that is only have pivot chart as subforms.

Please, if VBA is needed let me know as well. Any response or help would appreciated.

 

[John Big Booty]

Welcome to the forum.

Perhaps a Multi Select list box will do what you are after.

 

[qnikchen]

Hi John,

Thank you for taking your for helping me. I have checked the link, and it says that it is for report. Would that still work for form?

Thanks,

Quenica

 

[John Big Booty]

Yes, you will just need to adapt how you use the information once it has been extracted from the list box.