Dynamically update a list box and filter

[Mark_Lurie]

I have looked through all the examples and sat through a few tutorials but can't seem to find what I want to do.  

I want to be able to dynamically create the selections on my list box and then filter on my selections, however, I don't want to have to update the filter to do the replace.

Is this possible?

Thanks in advance.

Mark

[acastelazo]

The options need to be in different columns, so this might solve your issue:

[JordyMicheal · Accepted solution]

Hey Mark!

Super close for sure. Just missing a quick step!

I've attached the workflow.

All I did was copy your list into another field, then Cross Tab that to make the select list.

The data just needs to be structured a little differently to feed the select box!

This should dynamically work for anything you now add!

[Mark_Lurie]

That did the trick!  Thanks.

[LarryRippe]

This is a great example of what I just spent hours trying to figure out.   THANK YOU

[Nicholas_White]

Hello,

I found this discussion super useful, I was able to get from it more than the Help documentation or videos online. I spent about 2 days trying to figure the Action Tool out, this post had me up and running in about 5 minutes. 

Thanks,

Nick 

[sknowlesHS]

As soon as I read "The options need to be in different columns"....it clicked & your example helped me configure my macro properly. Thanks so much for your contribution.