Originally Posted by
pbaldy
If the values are text like your example, each needs to be in quotes:
'user1','user2'
Thank you! That was my problem. I updated the code to include a single quote at the beginning and end of the ConcatRelated function and then also added it as part of the (optional) delimitter argument.
The filter is now working as intended
Code:
strUsers = "'" & ConcatRelated("Assigned_UID", "qryMyForm_UIDs_With_Only_1_Record_Assigned", , , "','") & "'"
Me.Filter = "[Assigned UserID] IN (" & strUsers & ")"
Me.FilterOn = True