Multi Selections from List passed to Query

[Paul Cross]

I've got a form ("Select Multiple Departments") with a multi-select
list box ("cboMultipleDepartments").
I intend to use some code I found that loops through the selected
values and assigns them to a hidden field's control source
("ctlHiddenString")
I then have a query "qryMultipleDepartments" that uses that hidden
field as a criteria for selection.
My first attempt is to get this running w/ just 1 selection and try
the loop later. But I'm getting "Object Errors" and am not sure I've
got the code attached to the right events ...

My code is attached to the onClick event of a command button:

Private Sub cmdMultipleDepartments_Click()

Dim stDocName As String

'this next part I'd like to assign multiple select values.
'But I can't even get anything assigned (e.g. a constant)

Set ctlHiddenString.Value = HELPmeASSIGNsomethingHERE

'Then I would just open the query, where the text box
'ctlHiddenString provides criteria

stDocName = "qryInvestigate_Filtered_Multiple_Departments"
DoCmd.OpenQuery stDocName, acPreview


End Sub

When I click the command button with the above code i get "Object
Required"

Thanks for any suggestions
Paul Cross

 

[Roger Carlson]

Personally, I would modify (or re-create) the query programmatically and put
those values into an IN clause. On my website
(www.rogersaccesslibrary.com), is a small access sample database called
"CreateQueries2.mdb". On of the examples listed shows how to use a
multi-select listbox.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L