I need to use a List Lookup on my form that is filtered by multiple fields. Only one of the fields I need to use is dynamic so I set up a view for the rest of the fields and I'm trying to dynamically filter that view for this one field. But it doesn't work. The dynamic filtering works fine if I don't use the View but when I do, it doesn't. I'm not sure what I'm doing wrong. Here's my setup:
Source List: Name of list
Source view: Name of view
List column name: Name of field
Filter available selections: By a control's value (I also tried by a specific value)
Where field: Field name
Filtered by control: Control name
Action when no filter applied: Show none
This gives me all the items in my view without the filter applied.
If I take out the view name, then I get the all the list items with the filter applied.
What am I missing?
