search multi entries in only 1 menu

[magedalshaer]

I have form with multi select dropdown menu contain counties names enable me to choose more than one country , would like to use is it in a qry to return me all hotels in those different countries




When I select only 1 country it work , but if I select more it return me nothing



Pls. help
I don't wont to use VBA only qrys or macros

[June7]

How is this a multi-select dropdown - is it a combobox bound to a multi-value field? Sorry, query and macro cannot do this with a multi-select combobox.

Can use a multi-select listbox and then VBA code to loop through listbox to build a comma separated string. http://allenbrowne.com/ser-50.html

Alternative may be to have yes/no field in Countries table. Bind a checkbox to this field. User selects countries.

Then a query that joins Countries table with Hotels table can be filtered by the Yes/No field.