Multi-selection filtering for form or report

[PaulA]

Hi, all -

Is there a way to have a combobox, listbox or even a subform to create a multi-choice filter to pull up selected records in a form or report?

It's easy to do this for a single record, of course.

An example of its use would be to select from a list of staff so only the records related to the selected staff would be generated in the report.

I've thought of adding a field only for this: a check box field, say, but it would also be helpful to generate all records (a short of "Select All" in the filtering.

I'm using Access 2016 and most of this database is navigated in a primary navigation form.

I'd be interested in any methods others have devised.

Thanks!

Paul

 

[pbaldy]

Like this?

http://www.baldyweb.com/multiselect.htm

 

[PaulA]

It looks very much like what I'm wanting.

Thanks for the link, Paul.

 

[pbaldy]

Happy to help!