Populating a table using combo box, multiple selections

[finsmith]

I found this in another thread. it is similar to what I am looking for.
https://www.accessforums.net/program...tton-5441.html

I may be doing it incorrectly. But if it is possible to have a drop down box, selecting the item, hitting next (for the next item, not record) and then using sql or concat to join all the items together in a query.



I might be going about this wrong, I should probably be using a list box. again, storing multiple selections in the same field, for 1 record. is this possible?

thanks again.
(new access user)

[June7]

You can have multi-value fields but I never use them. And that won't really help you for filtering the records.

Yes, use an unbound listbox to select multiple filter criteria. Review: http://allenbrowne.com/ser-50.html

[finsmith]

MultiSelect.zip

I really dont care about having it filtering the records, I just want it to say, ok these three selections correspond with this record.
and then print the record ina query.
I was having trouble printing the query. I have this as an example. again new to access vb code

thanks.

[June7]

So what is the issue? The db you provided works. The report opens only with employees selected in the listbox.

[finsmith]

trying to propagate it into a query...

[June7]

Don't understand. The report in the db is working. The filtering takes place so it is 'propagated'.