Yet another Multi-select "how to" request

[CTQE]

Hello All,
I apologize for the question as there are many threads on this topic already, but the method for the multi-select list box is not clear to me.

What do I have to do in order to make a multi-select list box?
My query is looking for the entry on the form but I do not know how to present the multiple selection to the query.

Please help!
Thanks in advance.

FYI,
Form name = frmReports
List name = JobPositions
Field Name = Positions

 

[pbaldy]

It looks like this is for a report? I typically leave that criteria out of the query and do this:

http://www.baldyweb.com/multiselect.htm

 

[CTQE]

Almost there...

Thanks for that sample DB!

My command is stalling on this section of the script:

'open the report, restricted to the selected items
DoCmd.OpenReport "rptEmployees", acPreview, , "EmpID IN(" & strWhere & ")"

I can't seem to find my equalivalent to your "EmpID".

An error message returns that states: Syntax error (missing operator) in query expression '(StudentID IN(Inspector))'

Any thoughts?

 

[pbaldy]

You missed these two lines in the link:

'Use this line if your value is text
'strWhere = strWhere & "'" & ctl.ItemData(varItem) & "',"