So confused with multiselects

[darylclassen]

I have a form, with a multiselect list box (simple) on it. I also have a button that opens a query, and one of the columns in my query looks back at the listbox for it's criteria value. Well, I can't get this to work at all. I've read other posts, but I still can't seem to get it working. Can someone reccomend a newbie proof tutorial on this, as I'm having many problems with all the answers here? Thanks so much in advance.

 

[dhookom]

Roger Carlson has lots of small sample databases at

http://www.rogersaccesslibrary.com/TableOfContents2k.asp.

One of these demonstrates how to use a multi-select list box.

There is also an

http://www.tek-tips.com/faqs.cfm?spid=703&newpid=703&sfid=3936

that describes a generic multi-select function. This can be used to open a form or report based on selected items.

Duane
MS Access MVP