Query based on combo boxes and multi-select list box

[LonghronJ]

I have this report that is based on a query that has parameters from multiple combo boxes in a form. The criteria of the query appear like so,

 Like "*" & [forms]![myForm].[comboBox1] & "*"

It works perfectly fine now. However, I want to include a list box that would allow multiple selections. The list box's bound column is an ID column, which is numeric. How do I retrieve the results of the multi-selected values to a query criteria like I have from the combo boxes?

[ranman256]

Its MUCH easier to build queries by using a single select list box to add items to a 'pick table'. Then the query is a simple join. Zero programming.
Using multi select list box will take programming skills.

user dbl-clicks item, run append query
user deletes an items, run delete query

[LonghronJ]

So, in this case where AK, CA, and GA are selected, how do you feed that to a query criteria? In my case, AK, CA, and GA are bounded by associated ID, so the criteria for the query needs to be like 3 or 7 or 15 vs "AK" or "CA" or "GA".