Query with Picklist Crieteria - Part 2

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

OK - I've followed the instructions earlier to create unbound combo boxs that
show the crieteria I want. I'm also able to select several items from these
lists and save it to a text box.

Question: How to I get Multi-Select Values to appear as Query Crieteria?

I can get the query to work if one item is select but not several.

e.g. Part = 1234 (this works), Part = 1234 or 5678 (doesn't work)
 
Your criteria would need to resolve like:
Part IN ( 1234, 5678 )
Or
(Part =1234 Or Part = 5678)

This will not work for multiple values:
Part IN ( Forms!frmSelect!txtMultipleParts )
 
Back
Top