Populate multi listbox with filtered (only visible) table data

[chris01395]

Some guidance with this code would be much appreciated.

In a nutshell I try to show only filtered data (visible rows) from table in my multi column list box. I managed to get it working by copying filtered data and pasting to new table (filtered_tbl) and referencing that, but I thought it was a bit of a clunky solution and seemed to create problems in other areas of my form when text boxes etc. were not sure which table (actions_tbl or filtered_tbl to reference), so I thought I would go back and have another stab at trying to set the range from the original table with the filters applied.

Below code generates Run time error '70': Permission denied error, when I click debug, it highlights following line

Please Login or Register  to view this content.

The full code is here (adapted from another forum post I found);

Please Login or Register  to view this content.

[sintek]

Deleted....Mac user

[torachan]

Without full listing not sure how you are filtering.
Look through the code of the attached file it may give you some ideas.
The four comboboxes supply the filter string "ystr" and identify the filter field "X"
Each combination is separately passed through Sub FILTR which loads arrays which load the listbox with the visible rows.
The slight flicker is the table been filtered then reset.
See if the app works on your Mac first before trying to replicate any coding.
torachan.

[chris01395]

Thanks torachan, it was not exactly what I had in mind, but it was a help nonetheless. I will share my sheet on the forum soon (it is a bit of a mess at the moment) to demo what I am doing.

I am actually working on PC at the moment so no Mac issues with this project.