Array in Filter

  • Thread starter Thread starter Chris B
  • Start date Start date
C

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
 
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")
 
Back
Top