Multi-select List box value

[lavanyanaren]

Hello all,
I have been lookng for a couple of day now and close to giving up. I have a very simple access form (frmMain) that captures a list of zipcodes via a list box called lstZip

I want to be able to capture all the values selected in the lstZip, which is a lulti select list box (extended) and pass them into a query as a criteria.

Just so you know, i use Access 2007. If I can post the values from the multi-select list box to an invisible text box and then use the text box value as a query criteria, that will also work. I can think of the logic but cannot figure out the code. I am not a frequent coder. So with your reponse to my question, if you can tell me where exactly in my form I need to add that code, that will be helpful.

Any help is appreciated.

 

[hkimpact]

I found this example. Not sure if it will help.

http://access.mvps.org/access/forms/frm0007.htm

 

[boblarson]

It is easy if you use a Report.
http://www.baldyweb.com/multiselect.htm

But if you want to use a query directly you will need to modify the query's SQL through use of a QueryDef object in VBA.