Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10334

Autofilter Not Working with Multi-Select Fields in Form

Show all headers | View raw

I have an Access 2013 database that displays a large form on open.

Initially, the autofilter feature worked great. Users could click the drop-down arrow at the field header and get a quick list of checkbox items.

However, when I added a multi-select (multiple value) list boxes, this feature disappeared from every field on the form.

I could understand if this happened with the multi-select fields -- but why did it disappear from ALL fields.

To double-check it was the multi-select fields causing the issue, I removed them from the table. Upon saving the table again WITHOUT the fields, the autofilter function returned.

The users like the autofilter checkboxes - they are NOT fond of the "text filters" option.

Is there a way to have both the multi-select fields AND the autofilter features?

Thanks in advance.

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Autofilter Not Working with Multi-Select Fields in Form Anita Arnold <honolulalu@yahoo.com> - 2015-02-06 12:25 -0800
  Re: Autofilter Not Working with Multi-Select Fields in Form Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-07 07:07 -0800

csiph-web