Passing multiple selected items from a form to a query

[Guest]

Hello,

Can you please let me know how to pass multiple selected items from a list
box on a form to a query using the "IN-clause"? the field (productID) is a
text field. here is the sample code that doesn't work:

SELECT OrderDetail.ProductID
FROM OrderDetail
WHERE (((OrderDetail.ProductID)=[forms]![profit_margin]![lstItemsSelected]));

thanks you in advance!

Michelle

 

[[MVP] S.Clark]

Examine the Help file for ItemData and ItemsSelected. You have to step
through the collection of ItemsSelected to extract the item data. I
typically write this into an IN Clause.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Duane Hookom]

There is a generic function for doing this at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

Hey, Duane,

It works exactly how I wanted!! Thank you so much!

Michelle

There is a generic function for doing this at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP

Hello,

Can you please let me know how to pass multiple selected items from a list
box on a form to a query using the "IN-clause"? the field (productID) is
a
text field. here is the sample code that doesn't work:

SELECT OrderDetail.ProductID
FROM OrderDetail
WHERE
(((OrderDetail.ProductID)=[forms]![profit_margin]![lstItemsSelected]));

thanks you in advance!

Michelle