List multiple value in query

[mesba713]

Hello Everyone,
I hava a newbee question. I have a list in a form where the user can select multiple values. The list” Projekte” is based on the table “Projekte”.

I want to be able after the user selects multiple values from the list to use them in a query to show the respectful records.


For example if the user selects Project 1 and Project 2. I want to show the records where there are either Project 1 or Project 2.
Is that possible without VB as I have no knowledge of VB.

Thanks in advance

[NTC]

No that is not possible without VB. The multi select list box is not easily use-able as the criteria for a query. Partially of course because for a query it would be unclear whether the multiple options should be AND or OR which of course changes the query results dramatically. Rather that a multi select list box one instead needs to use a sub form of a table/query as well as have a check box field. With this type of set up one can establish multiple values that would be useable in a query.

[mesba713]

Thanks for the quick answer. I tried it actually with checkboxes and wasnt more succesfull. Can you please elaborate on how to do it in this case ?

[orange]

Here is a link to a video on Form/subform
Here is a link to a M$oft example of multiselections from a listbox.

[NTC]

* there would be a sub form, probably continuous, and that would have a check box field - with the ones you want checked
* then you can do a query of that table for 'All Checked'
* one can then make a query that joins the 'All Checked' to the table(s) with the data you want to see; this is your final record set
* one must run an update query to then clear those check boxes