Array in Filter

[Chris B]

I have an array that contains selected part numbers
selected from a list. How can I use the contents of the
array to filter data in a subform? Any ideas on how to
use it in a query or just in filter statement would be
appreciated!

Thanks

Chris B

 

[Allen Browne]

Pass the array into a function that takes a ParamArray argument.

The function will then add the delimiters and generate a string to use in
your filter. The end result will be:
[PartNum] IN ("zzz", "xx", "yyyy", "SomeOtherPart")